In [1]:
import altair as alt # Loading the altair library
import pandas as pd
In [2]:
alt.data_transformers.disable_max_rows()
Out[2]:
DataTransformerRegistry.enable('default')
In [3]:
# data from 2012
# https://drive.google.com/file/d/1fXJjst0rrlrFauppA8odQXOrdCEcmLaN/view?usp=sharing
Chicago = pd.read_csv('https://drive.google.com/uc?id=1fXJjst0rrlrFauppA8odQXOrdCEcmLaN')
Chicago
Out[3]:
ID Case Number Date Block IUCR Primary Type Description Location Description Arrest Domestic ... Location Historical Wards 2003-2015 Zip Codes Community Areas Census Tracts Wards Boundaries - ZIP Codes Police Districts Police Beats Wards 2023-
0 8953937 HW102973 12/31/2012 11:58:00 PM 037XX N NORA AVE 0610 BURGLARY FORCIBLE ENTRY RESIDENCE-GARAGE False False ... (41.947761848, -87.802170774) 39.0 22254.0 17.0 444.0 19.0 52.0 12.0 17.0 38.0
1 8954299 HW100700 12/31/2012 11:55:00 PM 058XX S MARYLAND AVE 0890 THEFT FROM BUILDING HOSPITAL BUILDING/GROUNDS False False ... (41.788699253, -87.604954085) 32.0 22260.0 8.0 154.0 33.0 60.0 24.0 132.0 3.0
2 8950836 HW100039 12/31/2012 11:55:00 PM 0000X E OHIO ST 2890 PUBLIC PEACE VIOLATION OTHER VIOLATION SIDEWALK True False ... (41.892507592, -87.626223996) 22.0 21182.0 37.0 626.0 36.0 6.0 14.0 74.0 42.0
3 8950918 HW100021 12/31/2012 11:55:00 PM 035XX W MONTROSE AVE 0610 BURGLARY FORCIBLE ENTRY OTHER False False ... (41.961089289, -87.716314748) 2.0 21538.0 16.0 56.0 12.0 39.0 1.0 9.0 33.0
4 8951459 HW100757 12/31/2012 11:50:00 PM 028XX N HALSTED ST 0890 THEFT FROM BUILDING RESIDENCE False False ... (41.933894393, -87.649052922) 38.0 4449.0 57.0 684.0 25.0 22.0 5.0 30.0 44.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
336320 8678186 HV352296 01/01/2012 12:00:00 AM 013XX W WASHBURNE AVE 1751 OFFENSE INVOLVING CHILDREN CRIM SEX ABUSE BY FAM MEMBER RESIDENCE False False ... (41.866098868, -87.659865054) 48.0 14920.0 29.0 96.0 26.0 43.0 15.0 150.0 28.0
336321 8647985 HV322951 01/01/2012 12:00:00 AM 015XX N CAMPBELL AVE 1305 CRIMINAL DAMAGE CRIMINAL DEFACEMENT RESIDENCE-GARAGE False False ... (41.909296674, -87.689653613) 10.0 21560.0 25.0 302.0 41.0 4.0 7.0 62.0 1.0
336322 8511440 HV188411 01/01/2012 12:00:00 AM 030XX W 64TH ST 0840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False ... (41.777209768, -87.69903082) 44.0 21867.0 64.0 319.0 31.0 58.0 13.0 276.0 15.0
336323 10928592 JA154782 01/01/2012 12:00:00 AM 0000X E 118TH PL 1752 OFFENSE INVOLVING CHILDREN AGG CRIM SEX ABUSE FAM MEMBER RESIDENCE True True ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
336324 9467940 HX120966 01/01/2012 12:00:00 AM 015XX S KEELER AVE 0840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False ... (41.860113198, -87.729881467) 36.0 21569.0 30.0 761.0 14.0 57.0 21.0 109.0 24.0

336325 rows × 31 columns

In [4]:
Chicago = Chicago.dropna()
In [5]:
Chicago_theft_sample = Chicago.sample(frac=1, random_state=42)
Chicago_theft_data = Chicago_theft_sample[Chicago_theft_sample["Primary Type"] == "THEFT"]
Chicago_theft_data
Out[5]:
ID Case Number Date Block IUCR Primary Type Description Location Description Arrest Domestic ... Location Historical Wards 2003-2015 Zip Codes Community Areas Census Tracts Wards Boundaries - ZIP Codes Police Districts Police Beats Wards 2023-
22474 8921124 HV592953 12/03/2012 10:00:00 PM 026XX W 35TH PL 0840 THEFT FINANCIAL ID THEFT: OVER $300 OTHER False False ... (41.829258146, -87.690690891) 29.0 22248.0 55.0 638.0 1.0 56.0 23.0 96.0 12.0
155202 8706239 HV382465 07/14/2012 01:30:00 AM 052XX S MICHIGAN AVE 0890 THEFT FROM BUILDING OTHER False False ... (41.799858243, -87.622596769) 12.0 21192.0 7.0 218.0 9.0 10.0 24.0 111.0 8.0
192972 8648938 HV324042 06/08/2012 04:15:00 AM 003XX N LA SALLE DR 0870 THEFT POCKET-PICKING STREET True False ... (41.888599915, -87.632510468) 22.0 4446.0 37.0 670.0 36.0 55.0 14.0 73.0 42.0
219443 8609272 HV282904 05/12/2012 02:00:00 AM 019XX W DIVERSEY PKWY 0820 THEFT $500 AND UNDER STREET False False ... (41.932306289, -87.676441918) 16.0 21190.0 68.0 649.0 40.0 16.0 5.0 172.0 32.0
87969 8813861 HV487221 09/21/2012 12:00:00 PM 007XX S CLAREMONT AVE 0820 THEFT $500 AND UNDER STREET False False ... (41.872184627, -87.684966578) 48.0 21184.0 29.0 757.0 23.0 28.0 15.0 139.0 28.0
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
264876 8535449 HV212046 03/23/2012 08:30:00 PM 001XX W HUBBARD ST 0890 THEFT FROM BUILDING RESTAURANT False False ... (41.890013524, -87.631664996) 22.0 4446.0 37.0 670.0 36.0 55.0 14.0 73.0 42.0
65276 8862096 HV535499 10/16/2012 04:00:00 PM 027XX E 89TH ST 0820 THEFT $500 AND UNDER SCHOOL, PUBLIC, BUILDING False False ... (41.73365047, -87.557845321) 43.0 21202.0 42.0 508.0 37.0 25.0 19.0 238.0 5.0
280207 8510397 HV187643 03/07/2012 07:30:00 PM 054XX N CUMBERLAND AVE 0890 THEFT FROM BUILDING OTHER False False ... (41.97855782, -87.836588785) 34.0 4448.0 36.0 735.0 29.0 31.0 12.0 44.0 41.0
192808 8650043 HV324578 06/08/2012 09:30:00 AM 024XX W ROOSEVELT RD 0820 THEFT $500 AND UNDER GAS STATION False False ... (41.866604054, -87.686645691) 11.0 14920.0 29.0 96.0 23.0 43.0 21.0 151.0 28.0
55272 8864755 HV538265 10/27/2012 12:00:00 PM 013XX N STATE PKWY 0890 THEFT FROM BUILDING HOTEL/MOTEL False False ... (41.906054951, -87.628752556) 22.0 14926.0 37.0 17.0 11.0 54.0 14.0 197.0 2.0

74683 rows × 31 columns

In [6]:
theft_counts_by_area = Chicago_theft_data.groupby('Community Area').size().reset_index()
theft_counts_by_area.columns = ['Community Area', 'Theft Count']

print(theft_counts_by_area)
    Community Area  Theft Count
0              1.0          959
1              2.0          963
2              3.0         1340
3              4.0          691
4              5.0          679
..             ...          ...
72            73.0          738
73            74.0          193
74            75.0          636
75            76.0          542
76            77.0          994

[77 rows x 2 columns]
In [7]:
df =pd.DataFrame(Chicago_theft_data)
print (df)
             ID Case Number                    Date                   Block  \
22474   8921124    HV592953  12/03/2012 10:00:00 PM         026XX W 35TH PL   
155202  8706239    HV382465  07/14/2012 01:30:00 AM    052XX S MICHIGAN AVE   
192972  8648938    HV324042  06/08/2012 04:15:00 AM     003XX N LA SALLE DR   
219443  8609272    HV282904  05/12/2012 02:00:00 AM   019XX W DIVERSEY PKWY   
87969   8813861    HV487221  09/21/2012 12:00:00 PM   007XX S CLAREMONT AVE   
...         ...         ...                     ...                     ...   
264876  8535449    HV212046  03/23/2012 08:30:00 PM      001XX W HUBBARD ST   
65276   8862096    HV535499  10/16/2012 04:00:00 PM         027XX E 89TH ST   
280207  8510397    HV187643  03/07/2012 07:30:00 PM  054XX N CUMBERLAND AVE   
192808  8650043    HV324578  06/08/2012 09:30:00 AM    024XX W ROOSEVELT RD   
55272   8864755    HV538265  10/27/2012 12:00:00 PM      013XX N STATE PKWY   

        IUCR Primary Type                    Description  \
22474   0840        THEFT  FINANCIAL ID THEFT: OVER $300   
155202  0890        THEFT                  FROM BUILDING   
192972  0870        THEFT                 POCKET-PICKING   
219443  0820        THEFT                 $500 AND UNDER   
87969   0820        THEFT                 $500 AND UNDER   
...      ...          ...                            ...   
264876  0890        THEFT                  FROM BUILDING   
65276   0820        THEFT                 $500 AND UNDER   
280207  0890        THEFT                  FROM BUILDING   
192808  0820        THEFT                 $500 AND UNDER   
55272   0890        THEFT                  FROM BUILDING   

            Location Description  Arrest  Domestic  ...  \
22474                      OTHER   False     False  ...   
155202                     OTHER   False     False  ...   
192972                    STREET    True     False  ...   
219443                    STREET   False     False  ...   
87969                     STREET   False     False  ...   
...                          ...     ...       ...  ...   
264876                RESTAURANT   False     False  ...   
65276   SCHOOL, PUBLIC, BUILDING   False     False  ...   
280207                     OTHER   False     False  ...   
192808               GAS STATION   False     False  ...   
55272                HOTEL/MOTEL   False     False  ...   

                             Location  Historical Wards 2003-2015  Zip Codes  \
22474   (41.829258146, -87.690690891)                        29.0    22248.0   
155202  (41.799858243, -87.622596769)                        12.0    21192.0   
192972  (41.888599915, -87.632510468)                        22.0     4446.0   
219443  (41.932306289, -87.676441918)                        16.0    21190.0   
87969   (41.872184627, -87.684966578)                        48.0    21184.0   
...                               ...                         ...        ...   
264876  (41.890013524, -87.631664996)                        22.0     4446.0   
65276    (41.73365047, -87.557845321)                        43.0    21202.0   
280207   (41.97855782, -87.836588785)                        34.0     4448.0   
192808  (41.866604054, -87.686645691)                        11.0    14920.0   
55272   (41.906054951, -87.628752556)                        22.0    14926.0   

        Community Areas Census Tracts  Wards  Boundaries - ZIP Codes  \
22474              55.0         638.0    1.0                    56.0   
155202              7.0         218.0    9.0                    10.0   
192972             37.0         670.0   36.0                    55.0   
219443             68.0         649.0   40.0                    16.0   
87969              29.0         757.0   23.0                    28.0   
...                 ...           ...    ...                     ...   
264876             37.0         670.0   36.0                    55.0   
65276              42.0         508.0   37.0                    25.0   
280207             36.0         735.0   29.0                    31.0   
192808             29.0          96.0   23.0                    43.0   
55272              37.0          17.0   11.0                    54.0   

        Police Districts Police Beats  Wards 2023-  
22474               23.0         96.0         12.0  
155202              24.0        111.0          8.0  
192972              14.0         73.0         42.0  
219443               5.0        172.0         32.0  
87969               15.0        139.0         28.0  
...                  ...          ...          ...  
264876              14.0         73.0         42.0  
65276               19.0        238.0          5.0  
280207              12.0         44.0         41.0  
192808              21.0        151.0         28.0  
55272               14.0        197.0          2.0  

[74683 rows x 31 columns]
In [8]:
ChicagoGeo = "https://gist.githubusercontent.com/juliasharkowicz/b0c20ccfc65a46bf1881657d35161b41/raw/32eb6f20c1aa98ce137b607fb598c9a7dd16eac0/gistfile1.txt"
geodata_chicago = alt.Data(url=ChicagoGeo, format=alt.DataFormat(property="features", type="json"))

chicago_land = alt.Chart(geodata_chicago).mark_geoshape(
    stroke='white',
    fill='lightgray'
).properties(
    width=800,  # Set the width to make the map wider
    height=600  # You can adjust the height as needed
)

chicago_land
Out[8]:
In [9]:
import altair as alt
import pandas as pd


Chicago1 = Chicago.head(5000)

Chicago2 = alt.Chart(Chicago1).mark_circle(opacity=0.4).encode(
    longitude =('Long:Q'),
    latitude = ('Lat:Q'),
    tooltip=['Long:Q', 'Lat:Q', 'Primary Type', 'Community Area'],
    color=alt.Color('Primary Type:N', scale=alt.Scale(scheme='magma') )  # Set color scheme to 'viridis'
).project(type ='albersUsa')
chicago_land + Chicago2
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():
Out[9]:
In [26]:
Chicago_theft_map = Chicago_theft_data.head(10000)

# Now, you can use this filtered dataframe to create your chart
Chicago3 = alt.Chart(Chicago_theft_map).mark_circle(opacity=0.2).encode(
    longitude=('Longitude:Q'),
    latitude=('Latitude:Q'),
    tooltip=['Longitude:Q', 'Latitude:Q', 'Primary Type','Community Area'],
    color=alt.Color('Primary Type:N', scale=alt.Scale(scheme='tableau10'))
).project(
    type='albersUsa'
)

# Assuming you've already defined chicago_land somewhere
chicago_land + Chicago3
Out[26]:
In [12]:
# merged the data sets using geodatamerger (merged the crime CSV with a CSV for socioeconomic factors)
# merged on "Community Area Number"and "community areas"
# https://drive.google.com/file/d/1c4_78Np5-DGePRzUGVLGrSluBoB2qo1l/view?usp=sharing
socioeconomicMerge = pd.read_csv("https://drive.google.com/uc?id=1c4_78Np5-DGePRzUGVLGrSluBoB2qo1l")
socioeconomicMerge

Chicago[['Latitude', 'Longitude']] = Chicago['Location'].str.extract(r'\((.*), (.*)\)')

Chicago['Latitude'] = pd.to_numeric(Chicago['Latitude'], errors='coerce')
Chicago['Longitude'] = pd.to_numeric(Chicago['Longitude'], errors='coerce')
import pandas as pd

pd.set_option('display.max_rows', 500)
pd.set_option('display.max_columns', 500)
pd.set_option('display.width', 1000)
/tmp/ipykernel_303/3919695009.py:7: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  Chicago[['Latitude', 'Longitude']] = Chicago['Location'].str.extract(r'\((.*), (.*)\)')
/tmp/ipykernel_303/3919695009.py:9: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  Chicago['Latitude'] = pd.to_numeric(Chicago['Latitude'], errors='coerce')
/tmp/ipykernel_303/3919695009.py:10: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy
  Chicago['Longitude'] = pd.to_numeric(Chicago['Longitude'], errors='coerce')
In [13]:
# calculates the percentage of crimes that are theft in each community area
grouped = Chicago.groupby('Community Area').apply(lambda x: (x['Primary Type'] == 'THEFT').sum() / len(x) * 100).reset_index()
grouped.columns = ['Community Area Number', 'Theft Percentage']

# Merge the theft percentage with your existing dataframe
socioeconomicMerge = socioeconomicMerge.merge(grouped, on='Community Area Number', how='left')



socioeconomicMerge
Out[13]:
Community Area Number COMMUNITY AREA NAME PERCENT OF HOUSING CROWDED PERCENT HOUSEHOLDS BELOW POVERTY PERCENT AGED 16+ UNEMPLOYED PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA PERCENT AGED UNDER 18 OR OVER 64 PER CAPITA INCOME HARDSHIP INDEX ID Case Number Date Block IUCR Primary Type Description Location Description Arrest Domestic Beat District Ward Community Area FBI Code X Coordinate Y Coordinate Year Updated On Latitude Longitude Location Historical Wards 2003-2015 Zip Codes Community Areas Census Tracts Wards Boundaries - ZIP Codes Police Districts Police Beats Wards 2023- Theft Percentage
0 1.0 Rogers Park 7.7 23.6 8.7 18.2 27.5 23939 39.0 8522872 HV199799 01/01/2012 12:01:00 AM 068XX N SHERIDAN RD 890 THEFT FROM BUILDING RESIDENCE False False 2431 24 49 1.0 06 1166981.0 1945453.0 2012 02/04/2016 06:33:39 AM 42.005888 -87.661005 (42.005887804, -87.661005031) 3.0 21853.0 10.0 267.0 5.0 9.0 11.0 39.0 49.0 20.071159
1 2.0 West Ridge 7.8 17.2 8.8 20.8 38.5 23040 46.0 8481432 HV158191 01/01/2012 12:00:00 AM 066XX N SEELEY AVE 1754 OFFENSE INVOLVING CHILDREN AGG SEX ASSLT OF CHILD FAM MBR RESIDENCE False False 2412 24 50 2.0 02 1161424.0 1944172.0 2012 02/10/2018 03:50:01 PM 42.002491 -87.681486 (42.002490631, -87.681485671) 42.0 22528.0 20.0 320.0 27.0 12.0 11.0 46.0 40.0 24.220322
2 3.0 Uptown 3.8 24.0 8.9 11.8 22.2 35787 20.0 9786892 HX434641 01/01/2012 12:00:00 AM 008XX W EASTWOOD AVE 266 CRIM SEXUAL ASSAULT PREDATORY RESIDENCE False True 1914 19 46 3.0 02 1169806.0 1931096.0 2012 02/10/2018 03:50:01 PM 41.966431 -87.651032 (41.966430564, -87.651032417) 37.0 22616.0 31.0 19.0 39.0 15.0 5.0 4.0 46.0 27.005240
3 4.0 Lincoln Square 3.4 10.9 8.2 13.4 25.5 37524 17.0 8639260 HV313362 01/01/2012 12:01:00 AM 048XX N CLAREMONT AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 2031 20 47 4.0 06 1159822.0 1932094.0 2012 02/04/2016 06:33:39 AM 41.969381 -87.687714 (41.969381427, -87.687714236) 13.0 21849.0 6.0 54.0 18.0 20.0 2.0 61.0 47.0 29.720430
4 5.0 North Center 0.3 7.5 5.2 4.5 26.2 57123 6.0 8719401 HV387013 01/01/2012 12:00:00 AM 040XX N HOYNE AVE 1563 SEX OFFENSE CRIMINAL SEXUAL ABUSE RESIDENCE False False 1911 19 47 5.0 17 1161635.0 1926718.0 2012 02/04/2016 06:33:39 AM 41.954592 -87.681198 (41.954591739, -87.681198274) 13.0 21538.0 46.0 623.0 18.0 39.0 5.0 10.0 47.0 35.475444
5 6.0 Lake View 1.1 11.4 4.7 2.6 17.0 60058 5.0 8856125 HV529988 01/01/2012 12:00:00 AM 006XX W CORNELIA AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 1925 19 46 6.0 06 1171080.0 1923465.0 2012 02/10/2018 03:50:01 PM 41.945463 -87.646573 (41.945462922, -87.646573015) 38.0 4449.0 57.0 730.0 25.0 22.0 5.0 18.0 44.0 37.566967
6 7.0 Lincoln Park 0.8 12.3 5.1 3.6 21.5 71551 2.0 8424740 HV103697 01/01/2012 12:00:00 AM 014XX W FULLERTON AVE 460 BATTERY SIMPLE APARTMENT False False 1931 19 32 7.0 08B 1166102.0 1916039.0 2012 02/10/2018 03:50:01 PM 41.925194 -87.665083 (41.925193578, -87.66508297) 16.0 21190.0 68.0 770.0 11.0 16.0 5.0 173.0 32.0 44.323671
7 8.0 Near North Side 1.9 12.9 7.0 2.5 22.6 88669 1.0 8904856 HV578917 01/01/2012 12:00:00 AM 002XX E CHESTNUT ST 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 1833 18 42 8.0 06 1178637.0 1906397.0 2012 02/10/2018 03:50:01 PM 41.898458 -87.619319 (41.898458275, -87.619318967) 22.0 21182.0 37.0 233.0 11.0 6.0 14.0 71.0 2.0 48.858488
8 9.0 Edison Park 1.1 3.3 6.5 7.4 35.3 40959 8.0 9274751 HW419186 01/01/2012 12:00:00 AM 073XX N ORIOLE AVE 2825 OTHER OFFENSE HARASSMENT BY TELEPHONE RESIDENCE False False 1611 16 41 9.0 26 1124738.0 1948147.0 2012 02/10/2018 03:50:01 PM 42.014085 -87.816364 (42.014085475, -87.81636423) 34.0 22243.0 77.0 653.0 29.0 17.0 12.0 34.0 41.0 22.442244
9 10.0 Norwood Park 2.0 5.4 9.0 11.5 39.5 32875 21.0 9055356 HW199594 01/01/2012 12:00:00 AM 057XX N WEST CIRCLE AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 STREET False False 1612 16 41 10.0 06 1127968.0 1937874.0 2012 02/10/2018 03:50:01 PM 41.985841 -87.804712 (41.985841282, -87.8047123) 34.0 22243.0 36.0 733.0 29.0 17.0 12.0 45.0 41.0 28.156028
10 11.0 Jefferson Park 2.7 8.6 12.4 13.4 35.5 27751 25.0 11865218 JC471748 01/01/2012 12:00:00 AM 062XX W FOSTER AVE 1750 OFFENSE INVOLVING CHILDREN CHILD ABUSE CHURCH/SYNAGOGUE/PLACE OF WORSHIP False True 1622 16 45 11.0 08B NaN NaN 2012 09/07/2021 03:41:02 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 25.854701
11 12.0 Forest Glen 1.1 7.5 6.8 4.9 40.5 44164 11.0 8548806 HV224880 01/01/2012 12:01:00 AM 062XX N KEYSTONE AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 STREET False False 1711 17 39 12.0 06 1148230.0 1941153.0 2012 02/04/2016 06:33:39 AM 41.994472 -87.730104 (41.9944717, -87.730103763) 28.0 22532.0 12.0 713.0 38.0 18.0 1.0 53.0 39.0 30.292599
12 13.0 North Park 3.9 13.2 9.9 14.4 39.0 26576 33.0 8679089 HV354082 01/01/2012 12:01:00 AM 040XX W PETERSON AVE 2820 OTHER OFFENSE TELEPHONE THREAT MEDICAL/DENTAL OFFICE False False 1711 17 39 13.0 26 1148144.0 1939564.0 2012 02/04/2016 06:33:39 AM 41.990113 -87.730461 (41.990113051, -87.730461261) 28.0 22532.0 13.0 748.0 38.0 18.0 1.0 53.0 39.0 30.252101
13 14.0 Albany Park 11.3 19.2 10.0 32.9 32.0 21323 53.0 8519160 HV194208 01/01/2012 12:00:00 AM 047XX N HARDING AVE 1562 SEX OFFENSE AGG CRIMINAL SEXUAL ABUSE RESIDENCE False False 1723 17 39 14.0 17 1149205.0 1931162.0 2012 02/04/2016 06:33:39 AM 41.967037 -87.726777 (41.96703686, -87.726777496) 28.0 21849.0 14.0 117.0 12.0 20.0 1.0 9.0 33.0 20.816327
14 15.0 Portage Park 4.1 11.6 12.6 19.3 34.0 24336 35.0 8460773 HV138026 01/01/2012 12:00:00 AM 050XX W WARWICK AVE 1563 SEX OFFENSE CRIMINAL SEXUAL ABUSE RESIDENCE False True 1634 16 45 15.0 17 1142107.0 1924463.0 2012 09/07/2021 03:41:02 PM 41.948789 -87.753043 (41.948789141, -87.753043017) 20.0 22618.0 15.0 360.0 50.0 21.0 12.0 26.0 30.0 25.741142
15 16.0 Irving Park 6.3 13.1 10.0 22.4 31.6 27249 34.0 8612446 HV286559 01/01/2012 12:01:00 AM 032XX N KILDARE AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 1731 17 31 16.0 06 1147143.0 1921400.0 2012 02/04/2016 06:33:39 AM 41.940289 -87.734610 (41.940288955, -87.734610033) 7.0 22618.0 16.0 328.0 21.0 21.0 1.0 25.0 30.0 21.792261
16 17.0 Dunning 5.2 10.6 10.0 16.2 33.6 26282 28.0 8630608 HV304221 01/01/2012 12:00:00 AM 065XX W BYRON ST 1562 SEX OFFENSE AGG CRIMINAL SEXUAL ABUSE RESIDENCE False True 1632 16 38 17.0 17 1132230.0 1925250.0 2012 02/04/2016 06:33:39 AM 41.951127 -87.789331 (41.951126516, -87.789331374) 25.0 22254.0 17.0 444.0 19.0 52.0 12.0 17.0 38.0 23.402007
17 18.0 Montclaire 8.1 15.3 13.8 23.5 38.6 22014 50.0 13184630 JG330270 01/01/2012 12:00:00 AM 070XX W DIVERSEY AVE 1754 OFFENSE INVOLVING CHILDREN AGGRAVATED SEXUAL ASSAULT OF CHILD BY FAMILY M... APARTMENT False True 2511 25 29 18.0 02 NaN NaN 2012 08/23/2023 03:41:55 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 20.079787
18 19.0 Belmont Cragin 10.8 18.7 14.6 37.3 37.3 15461 70.0 10433096 HZ170962 01/01/2012 12:00:00 AM 026XX N MC VICKER AVE 1562 SEX OFFENSE AGG CRIMINAL SEXUAL ABUSE RESIDENCE True True 2512 25 29 19.0 17 NaN NaN 2012 09/07/2021 03:41:02 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 19.055862
19 20.0 Hermosa 6.9 20.5 13.1 41.6 36.4 15089 71.0 11002368 JA329407 01/01/2012 12:00:00 AM 021XX N KENNETH AVE 1752 OFFENSE INVOLVING CHILDREN AGG CRIM SEX ABUSE FAM MEMBER RESIDENCE False True 2522 25 31 20.0 20 NaN NaN 2012 11/27/2017 03:53:35 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 16.113281
20 21.0 Avondale 6.0 15.3 9.2 24.7 31.0 20039 42.0 9485925 HX138962 01/01/2012 12:00:00 AM 033XX N KEDZIE AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 OTHER False False 1733 17 33 21.0 06 1154463.0 1921987.0 2012 02/04/2016 06:33:39 AM 41.941756 -87.707691 (41.941756281, -87.70769069) 15.0 21538.0 22.0 138.0 12.0 39.0 1.0 23.0 35.0 21.376147
21 22.0 Logan Square 3.2 16.8 8.2 14.8 26.2 31908 23.0 8580117 HV254276 01/01/2012 12:00:00 AM 037XX W LYNDALE ST 1751 OFFENSE INVOLVING CHILDREN CRIM SEX ABUSE BY FAM MEMBER RESIDENCE False True 2525 25 35 22.0 20 1151032.0 1914695.0 2012 02/04/2016 06:33:39 AM 41.921814 -87.720493 (41.921814446, -87.720492698) 15.0 22535.0 23.0 74.0 12.0 1.0 6.0 187.0 35.0 28.799527
22 23.0 Humboldt park 14.8 33.9 17.3 35.4 38.0 13781 85.0 10440733 HZ179414 01/01/2012 12:00:00 AM 038XX W OHIO ST 1153 DECEPTIVE PRACTICE FINANCIAL IDENTITY THEFT OVER $ 300 APARTMENT False False 1122 11 27 23.0 11 NaN NaN 2012 03/09/2016 04:05:56 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 14.008582
23 24.0 West Town 2.3 14.7 6.6 12.9 21.7 43198 10.0 8647985 HV322951 01/01/2012 12:00:00 AM 015XX N CAMPBELL AVE 1305 CRIMINAL DAMAGE CRIMINAL DEFACEMENT RESIDENCE-GARAGE False False 1423 14 1 24.0 14 1159459.0 1910195.0 2012 02/04/2016 06:33:39 AM 41.909297 -87.689654 (41.909296674, -87.689653613) 10.0 21560.0 25.0 302.0 41.0 4.0 7.0 62.0 1.0 32.515020
24 25.0 Austin 6.3 28.6 22.6 24.4 37.9 15957 73.0 10401057 HZ137709 01/01/2012 12:00:00 AM 050XX W HURON ST 1562 SEX OFFENSE AGG CRIMINAL SEXUAL ABUSE RESIDENCE False True 1532 15 28 25.0 17 NaN NaN 2012 02/11/2016 03:47:22 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 15.036232
25 26.0 West Garfield Park 9.4 41.7 25.8 24.5 43.6 10934 92.0 8421939 HV100656 01/01/2012 12:00:00 AM 044XX W WEST END AVE 890 THEFT FROM BUILDING RESIDENCE False False 1113 11 28 26.0 06 1146850.0 1900608.0 2012 02/04/2016 06:33:39 AM 41.883239 -87.736219 (41.883239213, -87.73621892) 11.0 21572.0 27.0 732.0 23.0 30.0 16.0 90.0 28.0 12.610586
26 27.0 East Garfield Park 8.2 42.4 19.6 21.3 43.2 12961 83.0 9087981 HW232769 01/01/2012 12:00:00 AM 008XX S INDEPENDENCE BLVD 841 THEFT FINANCIAL ID THEFT:$300 &UNDER RESIDENCE False False 1133 11 24 27.0 06 1151390.0 1896019.0 2012 02/10/2018 03:50:01 PM 41.870559 -87.719668 (41.870558601, -87.719668116) 36.0 21572.0 28.0 704.0 14.0 30.0 16.0 141.0 24.0 13.619433
27 28.0 Near West Side 3.8 20.6 10.7 9.6 22.2 44689 15.0 8678186 HV352296 01/01/2012 12:00:00 AM 013XX W WASHBURNE AVE 1751 OFFENSE INVOLVING CHILDREN CRIM SEX ABUSE BY FAM MEMBER RESIDENCE False False 1231 12 2 28.0 20 1167691.0 1894516.0 2012 02/04/2016 06:33:39 AM 41.866099 -87.659865 (41.866098868, -87.659865054) 48.0 14920.0 29.0 96.0 26.0 43.0 15.0 150.0 28.0 35.867363
28 29.0 North Lawndale 7.4 43.1 21.2 27.6 42.7 12034 87.0 9467940 HX120966 01/01/2012 12:00:00 AM 015XX S KEELER AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 1012 10 24 29.0 06 1148635.0 1892193.0 2012 02/10/2018 03:50:01 PM 41.860113 -87.729881 (41.860113198, -87.729881467) 36.0 21569.0 30.0 761.0 14.0 57.0 21.0 109.0 24.0 13.414282
29 30.0 South Lawndale 15.2 30.7 15.8 54.8 33.8 10402 96.0 11861733 JC473689 01/01/2012 12:00:00 AM 022XX S CALIFORNIA AVE 1754 OFFENSE INVOLVING CHILDREN AGG SEX ASSLT OF CHILD FAM MBR RESIDENCE False True 1033 10 12 30.0 02 NaN NaN 2012 10/16/2019 09:37:36 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 16.730236
30 31.0 Lower West Side 9.6 25.8 15.8 40.7 32.6 16444 76.0 8538123 HV214939 01/01/2012 12:01:00 AM 021XX W 18TH ST 1754 OFFENSE INVOLVING CHILDREN AGG SEX ASSLT OF CHILD FAM MBR RESIDENCE False False 1223 12 25 31.0 02 1162499.0 1891389.0 2012 02/04/2016 06:33:39 AM 41.857628 -87.679013 (41.857628272, -87.679012753) 8.0 14920.0 33.0 4.0 26.0 43.0 15.0 121.0 25.0 20.408163
31 32.0 Loop 1.5 14.7 5.7 3.1 13.5 65526 3.0 11655969 JC225381 01/01/2012 12:00:00 AM 001XX W RANDOLPH ST 486 BATTERY DOMESTIC BATTERY SIMPLE RESIDENCE False True 122 1 42 32.0 08B NaN NaN 2012 09/07/2021 03:41:02 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 53.431563
32 33.0 Near South Side 1.3 13.8 4.9 7.4 21.8 59077 7.0 8812790 HV485714 01/01/2012 12:01:00 AM 022XX S WABASH AVE 1150 DECEPTIVE PRACTICE CREDIT CARD FRAUD OTHER False False 131 1 2 33.0 11 1177098.0 1889498.0 2012 02/10/2018 03:50:01 PM 41.852121 -87.625483 (41.852121445, -87.625483421) 48.0 21194.0 34.0 193.0 9.0 40.0 22.0 94.0 8.0 39.086022
33 34.0 Armour Square 5.7 40.1 16.7 34.5 38.3 16148 82.0 8421660 HV100180 01/01/2012 01:20:00 AM 002XX W 26TH ST 430 BATTERY AGGRAVATED: OTHER DANG WEAPON PARKING LOT/GARAGE(NON.RESID.) True False 914 9 11 34.0 04B 1174834.0 1887065.0 2012 02/10/2018 03:50:01 PM 41.845496 -87.633866 (41.84549602, -87.633865582) 26.0 21194.0 35.0 346.0 48.0 40.0 23.0 157.0 7.0 27.890268
34 35.0 Douglas 1.8 29.6 18.2 14.3 30.7 23791 47.0 10532867 HZ276514 01/01/2012 12:00:00 AM 036XX S RHODES AVE 1563 SEX OFFENSE CRIMINAL SEXUAL ABUSE APARTMENT False True 212 2 4 35.0 17 NaN NaN 2012 09/07/2021 03:41:02 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 24.791893
35 36.0 Oakland 1.3 39.7 28.7 18.4 40.4 19252 78.0 8421472 HV100138 01/01/2012 01:38:00 AM 042XX S DREXEL BLVD 486 BATTERY DOMESTIC BATTERY SIMPLE APARTMENT False True 2123 2 4 36.0 08B 1182889.0 1876982.0 2012 02/10/2018 03:50:01 PM 41.817644 -87.604619 (41.817643766, -87.604618853) 1.0 4301.0 2.0 220.0 10.0 36.0 24.0 104.0 9.0 20.984456
36 37.0 Fuller Park 3.2 51.2 33.9 26.6 44.9 10432 97.0 9836248 HX484599 01/01/2012 12:00:00 AM 001XX W GARFIELD BLVD 1130 DECEPTIVE PRACTICE FRAUD OR CONFIDENCE GAME CURRENCY EXCHANGE True False 225 2 3 37.0 11 1176228.0 1868523.0 2012 02/10/2018 03:50:01 PM 41.794584 -87.629307 (41.794583892, -87.629307346) 12.0 21559.0 66.0 166.0 9.0 37.0 24.0 111.0 20.0 20.540098
37 38.0 Grand Boulevard 3.3 29.3 24.3 15.9 39.5 23472 57.0 8424419 HV102059 01/01/2012 03:00:00 AM 046XX S PRAIRIE AVE 281 CRIM SEXUAL ASSAULT NON-AGGRAVATED RESIDENCE False False 221 2 3 38.0 02 1178818.0 1874416.0 2012 02/10/2018 03:50:01 PM 41.810696 -87.619631 (41.810696214, -87.619630513) 12.0 4301.0 4.0 354.0 9.0 36.0 24.0 98.0 8.0 17.389187
38 39.0 Kenwood 2.4 21.7 15.7 11.3 35.4 35911 26.0 8916155 HV588860 01/01/2012 12:00:00 AM 050XX S LAKE SHORE DR W 840 THEFT FINANCIAL ID THEFT: OVER $300 APARTMENT False False 222 2 4 39.0 06 1188639.0 1871868.0 2012 02/10/2018 03:50:01 PM 41.803475 -87.583690 (41.803474876, -87.583690122) 1.0 21192.0 5.0 400.0 33.0 10.0 24.0 113.0 3.0 28.459821
39 40.0 Washington Park 5.6 42.1 28.6 25.4 42.8 13785 88.0 11571926 JC122968 01/01/2012 12:00:00 AM 059XX S INDIANA AVE 1751 OFFENSE INVOLVING CHILDREN CRIM SEX ABUSE BY FAM MEMBER APARTMENT True True 232 2 20 40.0 17 NaN NaN 2012 08/01/2019 03:45:33 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 14.751732
40 41.0 Hyde Park 1.5 18.4 8.4 4.3 26.2 39056 14.0 9091480 HW236506 01/01/2012 12:00:00 AM 055XX S COTTAGE GROVE AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 235 2 5 41.0 06 1182527.0 1868455.0 2012 02/10/2018 03:50:01 PM 41.794253 -87.606211 (41.794253414, -87.606211387) 32.0 22260.0 8.0 401.0 33.0 60.0 24.0 132.0 3.0 34.500784
41 42.0 Woodlawn 2.9 30.7 23.4 16.5 36.1 18672 58.0 8821354 HV494310 01/01/2012 12:01:00 AM 063XX S ST LAWRENCE AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 STREET False False 312 3 20 42.0 06 1181324.0 1863129.0 2012 02/10/2018 03:50:01 PM 41.779666 -87.610787 (41.779666218, -87.61078682) 53.0 22260.0 9.0 332.0 4.0 60.0 18.0 277.0 20.0 15.501576
42 43.0 South Shore 2.8 31.1 20.0 14.0 35.7 19398 55.0 9784782 HX433977 01/01/2012 12:00:00 AM 078XX S JEFFERY BLVD 265 CRIM SEXUAL ASSAULT AGGRAVATED: OTHER RESIDENCE False True 414 4 8 43.0 02 1190897.0 1853347.0 2012 09/07/2021 03:41:02 PM 41.752598 -87.576007 (41.752597535, -87.576007285) 9.0 22538.0 39.0 420.0 35.0 24.0 19.0 222.0 10.0 16.425246
43 44.0 Chatham 3.3 27.8 24.0 14.5 40.3 18881 60.0 11012707 JA342665 01/01/2012 12:00:00 AM 081XX S EVANS AVE 1153 DECEPTIVE PRACTICE FINANCIAL IDENTITY THEFT OVER $ 300 OTHER False False 631 6 6 44.0 11 NaN NaN 2012 07/11/2017 03:48:22 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 22.336009
44 45.0 Avalon Park 1.4 17.2 21.1 10.6 39.3 24454 41.0 8453833 HV101813 01/01/2012 12:01:00 AM 080XX S WOODLAWN AVE 1320 CRIMINAL DAMAGE TO VEHICLE STREET False False 411 4 8 45.0 14 1185609.0 1851926.0 2012 02/10/2018 03:50:01 PM 41.748824 -87.595430 (41.748824266, -87.595429995) 9.0 21546.0 41.0 133.0 35.0 61.0 19.0 224.0 10.0 25.055432
45 46.0 South Chicago 4.7 29.8 19.7 26.6 41.1 16579 75.0 8644620 HV319861 01/01/2012 12:00:00 AM 087XX S ESCANABA AVE 4651 OTHER OFFENSE SEX OFFENDER: FAIL REG NEW ADD RESIDENCE True False 423 4 10 46.0 26 1196905.0 1847568.0 2012 02/04/2016 06:33:39 AM 41.736592 -87.554183 (41.736592286, -87.554182677) 47.0 21202.0 42.0 509.0 47.0 25.0 19.0 238.0 6.0 14.649984
46 47.0 Burnside 6.8 33.0 18.6 19.3 42.7 12515 79.0 9535590 HX189319 01/01/2012 12:00:00 AM 092XX S DREXEL AVE 1153 DECEPTIVE PRACTICE FINANCIAL IDENTITY THEFT OVER $ 300 APARTMENT False False 413 4 8 47.0 11 1184166.0 1844031.0 2012 02/10/2018 03:50:01 PM 41.727193 -87.600964 (41.727193361, -87.600963809) 9.0 21546.0 43.0 472.0 35.0 61.0 19.0 246.0 10.0 17.415730
47 48.0 Calumet Heights 2.1 11.5 20.0 11.0 44.0 28887 38.0 8421496 HV100177 01/01/2012 02:10:00 AM 023XX E 91ST ST 2025 NARCOTICS POSS: HALLUCINOGENS STREET True False 413 4 7 48.0 18 1193236.0 1845085.0 2012 02/10/2018 03:50:01 PM 41.729869 -87.567705 (41.729869072, -87.56770535) 43.0 21202.0 44.0 492.0 37.0 25.0 19.0 246.0 5.0 29.205852
48 49.0 Roseland 2.5 19.8 20.3 16.9 41.2 17949 52.0 8630662 HV304328 01/01/2012 12:00:00 AM 111XX S PARNELL AVE 1562 SEX OFFENSE AGG CRIMINAL SEXUAL ABUSE RESIDENCE False True 2233 22 34 49.0 17 1174621.0 1831009.0 2012 02/04/2016 06:33:39 AM 41.691677 -87.636314 (41.691676649, -87.636314398) 45.0 21861.0 45.0 486.0 22.0 19.0 9.0 258.0 21.0 15.912117
49 50.0 Pullman 1.5 21.6 22.8 13.1 38.6 20588 51.0 10579715 HZ328636 01/01/2012 12:00:00 AM 007XX E 105TH PL 1562 SEX OFFENSE AGG CRIMINAL SEXUAL ABUSE RESIDENCE False True 512 5 9 50.0 17 NaN NaN 2012 09/07/2021 03:41:02 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 16.454690
50 51.0 South Deering 4.0 29.2 16.3 21.0 39.5 14685 65.0 9006102 HW153435 01/01/2012 12:01:00 AM 097XX S BRENNAN AVE 841 THEFT FINANCIAL ID THEFT:$300 &UNDER RESIDENCE False False 431 4 7 51.0 06 1193243.0 1840695.0 2012 02/10/2018 03:50:01 PM 41.717822 -87.567823 (41.717822323, -87.567822714) 43.0 21202.0 48.0 252.0 37.0 25.0 19.0 249.0 5.0 17.918314
51 52.0 East Side 6.8 19.2 12.1 31.9 42.8 17104 64.0 9130410 HW275140 01/01/2012 12:00:00 AM 109XX S BUFFALO AVE 1751 OFFENSE INVOLVING CHILDREN CRIM SEX ABUSE BY FAM MEMBER RESIDENCE False True 432 4 10 52.0 20 1199876.0 1833114.0 2012 09/07/2021 03:41:02 PM 41.696855 -87.543784 (41.696854988, -87.54378378) 47.0 21202.0 49.0 602.0 47.0 25.0 19.0 247.0 6.0 15.531178
52 53.0 West Pullman 3.3 25.9 19.4 20.5 42.1 16563 62.0 10928592 JA154782 01/01/2012 12:00:00 AM 0000X E 118TH PL 1752 OFFENSE INVOLVING CHILDREN AGG CRIM SEX ABUSE FAM MEMBER RESIDENCE True True 532 5 9 53.0 20 NaN NaN 2012 09/07/2021 03:41:02 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 14.940518
53 54.0 Riverdale 5.8 56.5 34.6 27.5 51.5 8201 98.0 12364874 JE229312 01/01/2012 12:00:00 AM 131XX S FORRESTVILLE AVE 1581 SEX OFFENSE NON-CONSENSUAL DISSEMINATION OF PRIVATE SEXUAL... RESIDENCE False False 533 5 9 54.0 17 NaN NaN 2012 05/14/2021 03:40:44 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 11.047619
54 55.0 Hegewisch 3.3 17.1 9.6 19.2 42.9 22677 44.0 8438703 HV116214 01/01/2012 12:01:00 AM 134XX S AVENUE M 2820 OTHER OFFENSE TELEPHONE THREAT RESIDENCE False True 433 4 10 55.0 26 1201758.0 1816513.0 2012 02/10/2018 03:50:01 PM 41.651253 -87.537455 (41.65125265, -87.537454574) 47.0 22250.0 52.0 787.0 47.0 26.0 19.0 259.0 6.0 19.376694
55 56.0 Garfield Ridge 2.6 8.8 11.3 19.3 38.1 26353 32.0 8964421 HW112128 01/01/2012 12:01:00 AM 044XX S KILPATRICK AVE 841 THEFT FINANCIAL ID THEFT:$300 &UNDER RESIDENCE False False 815 8 23 56.0 06 1145771.0 1874717.0 2012 02/10/2018 03:50:01 PM 41.812211 -87.740837 (41.812211369, -87.740837061) 35.0 22248.0 53.0 566.0 28.0 56.0 13.0 105.0 22.0 22.066694
56 57.0 Archer Heights 8.5 14.1 16.5 35.9 39.2 16134 67.0 8550554 HV226299 01/01/2012 12:01:00 AM 050XX S KOLIN AVE 1752 OFFENSE INVOLVING CHILDREN AGG CRIM SEX ABUSE FAM MEMBER RESIDENCE False False 815 8 23 57.0 20 1148213.0 1870883.0 2012 02/10/2018 03:50:01 PM 41.801644 -87.731978 (41.801643749, -87.731978113) 35.0 22248.0 54.0 697.0 8.0 56.0 13.0 105.0 14.0 21.171548
57 58.0 Brighton Park 14.4 23.6 13.9 45.1 39.3 13089 84.0 10774674 HZ540883 01/01/2012 12:01:00 AM 045XX S TROY ST 266 CRIM SEXUAL ASSAULT PREDATORY RESIDENCE False True 922 9 14 58.0 02 NaN NaN 2012 09/07/2021 03:41:02 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 15.966123
58 59.0 McKinley Park 7.2 18.7 13.4 32.9 35.6 16954 61.0 8558693 HV234189 01/01/2012 12:00:00 AM 037XX S WOLCOTT AVE 610 BURGLARY FORCIBLE ENTRY RESIDENCE False False 912 9 11 59.0 05 1164301.0 1879957.0 2012 02/04/2016 06:33:39 AM 41.826220 -87.672721 (41.826219832, -87.67272111) 26.0 14924.0 56.0 720.0 1.0 37.0 23.0 165.0 12.0 27.761194
59 60.0 Bridgeport 4.5 18.9 13.7 22.2 31.3 22694 43.0 8697316 HV373879 01/01/2012 12:00:00 AM 027XX S EMERALD AVE 1751 OFFENSE INVOLVING CHILDREN CRIM SEX ABUSE BY FAM MEMBER RESIDENCE False False 914 9 11 60.0 20 1171748.0 1886502.0 2012 02/04/2016 06:33:39 AM 41.844020 -87.645207 (41.844019513, -87.645207358) 26.0 21194.0 58.0 688.0 48.0 40.0 23.0 157.0 7.0 23.706100
60 61.0 New City 11.9 29.0 23.0 41.5 38.9 12765 91.0 11419858 JB400896 01/01/2012 12:00:00 AM 047XX S WOOD ST 1754 OFFENSE INVOLVING CHILDREN AGG SEX ASSLT OF CHILD FAM MBR APARTMENT True True 931 9 15 61.0 02 NaN NaN 2012 01/24/2019 04:13:10 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 16.715586
61 62.0 West Elsdon 11.1 15.6 16.7 37.0 37.7 15754 69.0 8509166 HV186479 01/01/2012 12:01:00 AM 051XX S PULASKI RD 1305 CRIMINAL DAMAGE CRIMINAL DEFACEMENT DEPARTMENT STORE True False 815 8 23 62.0 14 1150563.0 1870470.0 2012 02/10/2018 03:50:01 PM 41.800465 -87.723370 (41.800464977, -87.723370404) 35.0 22248.0 60.0 792.0 6.0 56.0 13.0 129.0 23.0 21.418129
62 63.0 Gage Park 15.8 23.4 18.2 51.5 38.8 12171 93.0 8688452 HV363336 01/01/2012 12:00:00 AM 055XX S HOMAN AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 OTHER False False 822 8 14 63.0 06 1154655.0 1867673.0 2012 02/04/2016 06:33:39 AM 41.792709 -87.708438 (41.792708947, -87.708438164) 49.0 21867.0 61.0 801.0 8.0 58.0 13.0 129.0 14.0 17.424946
63 64.0 Clearing 2.7 8.9 9.5 18.8 37.6 25113 29.0 9030494 HW173536 01/01/2012 12:00:00 AM 063XX W 63RD ST 890 THEFT FROM BUILDING BANK False False 812 8 23 64.0 06 1135055.0 1862066.0 2012 02/10/2018 03:50:01 PM 41.777691 -87.780442 (41.777690785, -87.780442441) 35.0 22268.0 62.0 265.0 15.0 7.0 13.0 272.0 13.0 20.194647
64 65.0 West Lawn 5.8 14.9 9.6 33.6 39.6 16907 56.0 10244439 HY432505 01/01/2012 12:00:00 AM 039XX W 63RD PL 1153 DECEPTIVE PRACTICE FINANCIAL IDENTITY THEFT OVER $ 300 RESIDENCE False False 823 8 13 65.0 11 1151174.0 1862198.0 2012 02/10/2018 03:50:01 PM 41.777753 -87.721346 (41.777753427, -87.721345586) 23.0 21867.0 63.0 238.0 15.0 58.0 13.0 276.0 23.0 32.592593
65 66.0 Chicago Lawn 7.6 27.9 17.1 31.2 40.6 13231 80.0 8511440 HV188411 01/01/2012 12:00:00 AM 030XX W 64TH ST 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 823 8 15 66.0 06 1157262.0 1862044.0 2012 02/04/2016 06:33:39 AM 41.777210 -87.699031 (41.777209768, -87.69903082) 44.0 21867.0 64.0 319.0 31.0 58.0 13.0 276.0 15.0 15.625000
66 67.0 West Englewood 4.8 34.4 35.9 26.3 40.7 11317 89.0 8422478 HV100112 01/01/2012 12:00:00 AM 057XX S THROOP ST 486 BATTERY DOMESTIC BATTERY SIMPLE VEHICLE NON-COMMERCIAL False True 713 7 16 67.0 08B 1168636.0 1866805.0 2012 09/07/2021 03:41:02 PM 41.790037 -87.657197 (41.790036743, -87.657196537) 19.0 22257.0 65.0 297.0 2.0 23.0 17.0 266.0 16.0 15.349910
67 68.0 Englewood 3.8 46.6 28.0 28.5 42.5 11888 94.0 8489737 HV166954 01/01/2012 12:00:00 AM 067XX S NORMAL BLVD 1150 DECEPTIVE PRACTICE CREDIT CARD FRAUD RESIDENCE False False 722 7 6 68.0 11 1174118.0 1859976.0 2012 02/10/2018 03:50:01 PM 41.771177 -87.637298 (41.771177146, -87.637298335) 31.0 21559.0 66.0 479.0 32.0 11.0 17.0 201.0 4.0 15.333774
68 69.0 Greater Grand Crossing 3.6 29.6 23.0 16.5 41.0 17285 66.0 8577653 HV252006 01/01/2012 12:01:00 AM 001XX E 78TH ST 2825 OTHER OFFENSE HARASSMENT BY TELEPHONE APARTMENT False False 623 6 6 69.0 26 1178686.0 1853331.0 2012 02/04/2016 06:33:39 AM 41.752840 -87.620756 (41.752839871, -87.620755566) 31.0 21546.0 67.0 475.0 32.0 61.0 20.0 228.0 4.0 15.270766
69 70.0 Ashburn 4.0 10.4 11.7 17.7 36.9 23482 37.0 8621247 HV291039 01/01/2012 12:00:00 AM 028XX W 84TH PL 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 835 8 18 70.0 06 1158673.0 1848550.0 2012 02/04/2016 06:33:39 AM 41.740151 -87.694226 (41.740151493, -87.694225587) 6.0 4300.0 69.0 217.0 30.0 8.0 13.0 226.0 18.0 20.178042
70 71.0 Auburn Gresham 4.0 27.6 28.3 18.5 41.9 15528 74.0 12448101 JE331623 01/01/2012 12:00:00 AM 079XX S ELIZABETH ST 1195 DECEPTIVE PRACTICE FINANCIAL EXPLOITATION OF AN ELDERLY OR DISABL... RESIDENCE False False 612 6 21 71.0 11 NaN NaN 2012 08/10/2021 03:41:28 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 15.192430
71 72.0 Beverly 0.9 5.1 8.0 3.7 40.5 39523 12.0 8692747 HV368620 01/01/2012 12:00:00 AM 090XX S OAKLEY AVE 2825 OTHER OFFENSE HARASSMENT BY TELEPHONE RESIDENCE False False 2221 22 19 72.0 26 1162617.0 1844687.0 2012 02/04/2016 06:33:39 AM 41.729470 -87.679883 (41.729469531, -87.679882632) 33.0 22212.0 71.0 627.0 42.0 59.0 9.0 245.0 19.0 29.906542
72 73.0 Washington Height 1.1 16.9 20.8 13.7 42.6 19713 48.0 12586134 JF104706 01/01/2012 12:00:00 AM 010XX W 97TH PL 1153 DECEPTIVE PRACTICE FINANCIAL IDENTITY THEFT OVER $ 300 NaN False False 2223 22 34 73.0 11 NaN NaN 2012 01/07/2022 03:44:31 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 18.636364
73 74.0 Mount Greenwood 1.0 3.4 8.7 4.3 36.8 34381 16.0 9566017 HX216941 01/01/2012 12:01:00 AM 032XX W 114TH ST 1751 OFFENSE INVOLVING CHILDREN CRIM SEX ABUSE BY FAM MEMBER RESIDENCE False True 2211 22 19 74.0 20 1156983.0 1829019.0 2012 09/07/2021 03:41:02 PM 41.686589 -87.700943 (41.686589225, -87.70094317) 33.0 4447.0 73.0 264.0 42.0 33.0 9.0 254.0 19.0 29.601227
74 75.0 Morgan Park 0.8 13.2 15.0 10.8 40.3 27149 30.0 8903224 HV577354 01/01/2012 12:00:00 AM 013XX W 112TH PL 841 THEFT FINANCIAL ID THEFT:$300 &UNDER RESIDENCE False False 2234 22 34 75.0 06 1169238.0 1830118.0 2012 02/10/2018 03:50:01 PM 41.689349 -87.656048 (41.689349439, -87.656047862) 45.0 22212.0 74.0 663.0 22.0 13.0 9.0 263.0 21.0 23.643123
75 76.0 O'Hare 3.6 15.4 7.1 10.9 30.3 25828 24.0 8421756 HV100392 01/01/2012 05:30:00 AM 052XX N OAKVIEW AVE 1365 CRIMINAL TRESPASS TO RESIDENCE OTHER True False 1614 16 41 76.0 26 1117315.0 1933551.0 2012 02/10/2018 03:50:01 PM 41.974152 -87.843985 (41.9741522, -87.843985377) 34.0 4448.0 75.0 8.0 29.0 31.0 12.0 44.0 41.0 31.203224
76 77.0 Edgewater 4.1 18.2 9.2 9.7 23.8 33385 19.0 11206130 JB117907 01/01/2012 12:00:00 AM 059XX N RIDGE AVE 266 CRIM SEXUAL ASSAULT PREDATORY RESIDENCE False True 2013 20 48 77.0 02 NaN NaN 2012 05/14/2019 04:05:19 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 30.444104
77 NaN CHICAGO 4.7 19.7 12.9 19.5 33.5 28202 NaN 8421956 HV100653 01/01/2012 11:15:00 AM 083XX S HOLLAND RD 860 THEFT RETAIL THEFT DEPARTMENT STORE True False 622 6 21 NaN 06 1175640.0 1849717.0 2012 02/04/2016 06:33:39 AM 41.742991 -87.632026 (41.742991296, -87.632025815) 18.0 21554.0 40.0 1.0 13.0 59.0 20.0 236.0 21.0 NaN
In [14]:
# calculates
theft_counts = Chicago.groupby('Community Area').apply(lambda x: (x['Primary Type'] == 'THEFT').sum()).reset_index()
theft_counts.columns = ['Community Area Number', 'Theft Count']

# Merge the theft counts with the socioeconomicMerge dataframe
socioeconomicMerge = socioeconomicMerge.merge(theft_counts, on='Community Area Number', how='left')

# Fill NaN values in 'Theft Count' column with 0 (assuming that NaN means no thefts were reported)
#socioeconomicMerge['Theft Count'] = socioeconomicMerge['Theft Count'].fillna(0)


socioeconomicMerge
Out[14]:
Community Area Number COMMUNITY AREA NAME PERCENT OF HOUSING CROWDED PERCENT HOUSEHOLDS BELOW POVERTY PERCENT AGED 16+ UNEMPLOYED PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA PERCENT AGED UNDER 18 OR OVER 64 PER CAPITA INCOME HARDSHIP INDEX ID Case Number Date Block IUCR Primary Type Description Location Description Arrest Domestic Beat District Ward Community Area FBI Code X Coordinate Y Coordinate Year Updated On Latitude Longitude Location Historical Wards 2003-2015 Zip Codes Community Areas Census Tracts Wards Boundaries - ZIP Codes Police Districts Police Beats Wards 2023- Theft Percentage Theft Count
0 1.0 Rogers Park 7.7 23.6 8.7 18.2 27.5 23939 39.0 8522872 HV199799 01/01/2012 12:01:00 AM 068XX N SHERIDAN RD 890 THEFT FROM BUILDING RESIDENCE False False 2431 24 49 1.0 06 1166981.0 1945453.0 2012 02/04/2016 06:33:39 AM 42.005888 -87.661005 (42.005887804, -87.661005031) 3.0 21853.0 10.0 267.0 5.0 9.0 11.0 39.0 49.0 20.071159 959.0
1 2.0 West Ridge 7.8 17.2 8.8 20.8 38.5 23040 46.0 8481432 HV158191 01/01/2012 12:00:00 AM 066XX N SEELEY AVE 1754 OFFENSE INVOLVING CHILDREN AGG SEX ASSLT OF CHILD FAM MBR RESIDENCE False False 2412 24 50 2.0 02 1161424.0 1944172.0 2012 02/10/2018 03:50:01 PM 42.002491 -87.681486 (42.002490631, -87.681485671) 42.0 22528.0 20.0 320.0 27.0 12.0 11.0 46.0 40.0 24.220322 963.0
2 3.0 Uptown 3.8 24.0 8.9 11.8 22.2 35787 20.0 9786892 HX434641 01/01/2012 12:00:00 AM 008XX W EASTWOOD AVE 266 CRIM SEXUAL ASSAULT PREDATORY RESIDENCE False True 1914 19 46 3.0 02 1169806.0 1931096.0 2012 02/10/2018 03:50:01 PM 41.966431 -87.651032 (41.966430564, -87.651032417) 37.0 22616.0 31.0 19.0 39.0 15.0 5.0 4.0 46.0 27.005240 1340.0
3 4.0 Lincoln Square 3.4 10.9 8.2 13.4 25.5 37524 17.0 8639260 HV313362 01/01/2012 12:01:00 AM 048XX N CLAREMONT AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 2031 20 47 4.0 06 1159822.0 1932094.0 2012 02/04/2016 06:33:39 AM 41.969381 -87.687714 (41.969381427, -87.687714236) 13.0 21849.0 6.0 54.0 18.0 20.0 2.0 61.0 47.0 29.720430 691.0
4 5.0 North Center 0.3 7.5 5.2 4.5 26.2 57123 6.0 8719401 HV387013 01/01/2012 12:00:00 AM 040XX N HOYNE AVE 1563 SEX OFFENSE CRIMINAL SEXUAL ABUSE RESIDENCE False False 1911 19 47 5.0 17 1161635.0 1926718.0 2012 02/04/2016 06:33:39 AM 41.954592 -87.681198 (41.954591739, -87.681198274) 13.0 21538.0 46.0 623.0 18.0 39.0 5.0 10.0 47.0 35.475444 679.0
5 6.0 Lake View 1.1 11.4 4.7 2.6 17.0 60058 5.0 8856125 HV529988 01/01/2012 12:00:00 AM 006XX W CORNELIA AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 1925 19 46 6.0 06 1171080.0 1923465.0 2012 02/10/2018 03:50:01 PM 41.945463 -87.646573 (41.945462922, -87.646573015) 38.0 4449.0 57.0 730.0 25.0 22.0 5.0 18.0 44.0 37.566967 2875.0
6 7.0 Lincoln Park 0.8 12.3 5.1 3.6 21.5 71551 2.0 8424740 HV103697 01/01/2012 12:00:00 AM 014XX W FULLERTON AVE 460 BATTERY SIMPLE APARTMENT False False 1931 19 32 7.0 08B 1166102.0 1916039.0 2012 02/10/2018 03:50:01 PM 41.925194 -87.665083 (41.925193578, -87.66508297) 16.0 21190.0 68.0 770.0 11.0 16.0 5.0 173.0 32.0 44.323671 2202.0
7 8.0 Near North Side 1.9 12.9 7.0 2.5 22.6 88669 1.0 8904856 HV578917 01/01/2012 12:00:00 AM 002XX E CHESTNUT ST 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 1833 18 42 8.0 06 1178637.0 1906397.0 2012 02/10/2018 03:50:01 PM 41.898458 -87.619319 (41.898458275, -87.619318967) 22.0 21182.0 37.0 233.0 11.0 6.0 14.0 71.0 2.0 48.858488 5500.0
8 9.0 Edison Park 1.1 3.3 6.5 7.4 35.3 40959 8.0 9274751 HW419186 01/01/2012 12:00:00 AM 073XX N ORIOLE AVE 2825 OTHER OFFENSE HARASSMENT BY TELEPHONE RESIDENCE False False 1611 16 41 9.0 26 1124738.0 1948147.0 2012 02/10/2018 03:50:01 PM 42.014085 -87.816364 (42.014085475, -87.81636423) 34.0 22243.0 77.0 653.0 29.0 17.0 12.0 34.0 41.0 22.442244 68.0
9 10.0 Norwood Park 2.0 5.4 9.0 11.5 39.5 32875 21.0 9055356 HW199594 01/01/2012 12:00:00 AM 057XX N WEST CIRCLE AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 STREET False False 1612 16 41 10.0 06 1127968.0 1937874.0 2012 02/10/2018 03:50:01 PM 41.985841 -87.804712 (41.985841282, -87.8047123) 34.0 22243.0 36.0 733.0 29.0 17.0 12.0 45.0 41.0 28.156028 397.0
10 11.0 Jefferson Park 2.7 8.6 12.4 13.4 35.5 27751 25.0 11865218 JC471748 01/01/2012 12:00:00 AM 062XX W FOSTER AVE 1750 OFFENSE INVOLVING CHILDREN CHILD ABUSE CHURCH/SYNAGOGUE/PLACE OF WORSHIP False True 1622 16 45 11.0 08B NaN NaN 2012 09/07/2021 03:41:02 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 25.854701 363.0
11 12.0 Forest Glen 1.1 7.5 6.8 4.9 40.5 44164 11.0 8548806 HV224880 01/01/2012 12:01:00 AM 062XX N KEYSTONE AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 STREET False False 1711 17 39 12.0 06 1148230.0 1941153.0 2012 02/04/2016 06:33:39 AM 41.994472 -87.730104 (41.9944717, -87.730103763) 28.0 22532.0 12.0 713.0 38.0 18.0 1.0 53.0 39.0 30.292599 176.0
12 13.0 North Park 3.9 13.2 9.9 14.4 39.0 26576 33.0 8679089 HV354082 01/01/2012 12:01:00 AM 040XX W PETERSON AVE 2820 OTHER OFFENSE TELEPHONE THREAT MEDICAL/DENTAL OFFICE False False 1711 17 39 13.0 26 1148144.0 1939564.0 2012 02/04/2016 06:33:39 AM 41.990113 -87.730461 (41.990113051, -87.730461261) 28.0 22532.0 13.0 748.0 38.0 18.0 1.0 53.0 39.0 30.252101 324.0
13 14.0 Albany Park 11.3 19.2 10.0 32.9 32.0 21323 53.0 8519160 HV194208 01/01/2012 12:00:00 AM 047XX N HARDING AVE 1562 SEX OFFENSE AGG CRIMINAL SEXUAL ABUSE RESIDENCE False False 1723 17 39 14.0 17 1149205.0 1931162.0 2012 02/04/2016 06:33:39 AM 41.967037 -87.726777 (41.96703686, -87.726777496) 28.0 21849.0 14.0 117.0 12.0 20.0 1.0 9.0 33.0 20.816327 612.0
14 15.0 Portage Park 4.1 11.6 12.6 19.3 34.0 24336 35.0 8460773 HV138026 01/01/2012 12:00:00 AM 050XX W WARWICK AVE 1563 SEX OFFENSE CRIMINAL SEXUAL ABUSE RESIDENCE False True 1634 16 45 15.0 17 1142107.0 1924463.0 2012 09/07/2021 03:41:02 PM 41.948789 -87.753043 (41.948789141, -87.753043017) 20.0 22618.0 15.0 360.0 50.0 21.0 12.0 26.0 30.0 25.741142 1068.0
15 16.0 Irving Park 6.3 13.1 10.0 22.4 31.6 27249 34.0 8612446 HV286559 01/01/2012 12:01:00 AM 032XX N KILDARE AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 1731 17 31 16.0 06 1147143.0 1921400.0 2012 02/04/2016 06:33:39 AM 41.940289 -87.734610 (41.940288955, -87.734610033) 7.0 22618.0 16.0 328.0 21.0 21.0 1.0 25.0 30.0 21.792261 856.0
16 17.0 Dunning 5.2 10.6 10.0 16.2 33.6 26282 28.0 8630608 HV304221 01/01/2012 12:00:00 AM 065XX W BYRON ST 1562 SEX OFFENSE AGG CRIMINAL SEXUAL ABUSE RESIDENCE False True 1632 16 38 17.0 17 1132230.0 1925250.0 2012 02/04/2016 06:33:39 AM 41.951127 -87.789331 (41.951126516, -87.789331374) 25.0 22254.0 17.0 444.0 19.0 52.0 12.0 17.0 38.0 23.402007 443.0
17 18.0 Montclaire 8.1 15.3 13.8 23.5 38.6 22014 50.0 13184630 JG330270 01/01/2012 12:00:00 AM 070XX W DIVERSEY AVE 1754 OFFENSE INVOLVING CHILDREN AGGRAVATED SEXUAL ASSAULT OF CHILD BY FAMILY M... APARTMENT False True 2511 25 29 18.0 02 NaN NaN 2012 08/23/2023 03:41:55 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 20.079787 151.0
18 19.0 Belmont Cragin 10.8 18.7 14.6 37.3 37.3 15461 70.0 10433096 HZ170962 01/01/2012 12:00:00 AM 026XX N MC VICKER AVE 1562 SEX OFFENSE AGG CRIMINAL SEXUAL ABUSE RESIDENCE True True 2512 25 29 19.0 17 NaN NaN 2012 09/07/2021 03:41:02 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 19.055862 1211.0
19 20.0 Hermosa 6.9 20.5 13.1 41.6 36.4 15089 71.0 11002368 JA329407 01/01/2012 12:00:00 AM 021XX N KENNETH AVE 1752 OFFENSE INVOLVING CHILDREN AGG CRIM SEX ABUSE FAM MEMBER RESIDENCE False True 2522 25 31 20.0 20 NaN NaN 2012 11/27/2017 03:53:35 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 16.113281 330.0
20 21.0 Avondale 6.0 15.3 9.2 24.7 31.0 20039 42.0 9485925 HX138962 01/01/2012 12:00:00 AM 033XX N KEDZIE AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 OTHER False False 1733 17 33 21.0 06 1154463.0 1921987.0 2012 02/04/2016 06:33:39 AM 41.941756 -87.707691 (41.941756281, -87.70769069) 15.0 21538.0 22.0 138.0 12.0 39.0 1.0 23.0 35.0 21.376147 699.0
21 22.0 Logan Square 3.2 16.8 8.2 14.8 26.2 31908 23.0 8580117 HV254276 01/01/2012 12:00:00 AM 037XX W LYNDALE ST 1751 OFFENSE INVOLVING CHILDREN CRIM SEX ABUSE BY FAM MEMBER RESIDENCE False True 2525 25 35 22.0 20 1151032.0 1914695.0 2012 02/04/2016 06:33:39 AM 41.921814 -87.720493 (41.921814446, -87.720492698) 15.0 22535.0 23.0 74.0 12.0 1.0 6.0 187.0 35.0 28.799527 1948.0
22 23.0 Humboldt park 14.8 33.9 17.3 35.4 38.0 13781 85.0 10440733 HZ179414 01/01/2012 12:00:00 AM 038XX W OHIO ST 1153 DECEPTIVE PRACTICE FINANCIAL IDENTITY THEFT OVER $ 300 APARTMENT False False 1122 11 27 23.0 11 NaN NaN 2012 03/09/2016 04:05:56 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 14.008582 1567.0
23 24.0 West Town 2.3 14.7 6.6 12.9 21.7 43198 10.0 8647985 HV322951 01/01/2012 12:00:00 AM 015XX N CAMPBELL AVE 1305 CRIMINAL DAMAGE CRIMINAL DEFACEMENT RESIDENCE-GARAGE False False 1423 14 1 24.0 14 1159459.0 1910195.0 2012 02/04/2016 06:33:39 AM 41.909297 -87.689654 (41.909296674, -87.689653613) 10.0 21560.0 25.0 302.0 41.0 4.0 7.0 62.0 1.0 32.515020 3139.0
24 25.0 Austin 6.3 28.6 22.6 24.4 37.9 15957 73.0 10401057 HZ137709 01/01/2012 12:00:00 AM 050XX W HURON ST 1562 SEX OFFENSE AGG CRIMINAL SEXUAL ABUSE RESIDENCE False True 1532 15 28 25.0 17 NaN NaN 2012 02/11/2016 03:47:22 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 15.036232 3154.0
25 26.0 West Garfield Park 9.4 41.7 25.8 24.5 43.6 10934 92.0 8421939 HV100656 01/01/2012 12:00:00 AM 044XX W WEST END AVE 890 THEFT FROM BUILDING RESIDENCE False False 1113 11 28 26.0 06 1146850.0 1900608.0 2012 02/04/2016 06:33:39 AM 41.883239 -87.736219 (41.883239213, -87.73621892) 11.0 21572.0 27.0 732.0 23.0 30.0 16.0 90.0 28.0 12.610586 841.0
26 27.0 East Garfield Park 8.2 42.4 19.6 21.3 43.2 12961 83.0 9087981 HW232769 01/01/2012 12:00:00 AM 008XX S INDEPENDENCE BLVD 841 THEFT FINANCIAL ID THEFT:$300 &UNDER RESIDENCE False False 1133 11 24 27.0 06 1151390.0 1896019.0 2012 02/10/2018 03:50:01 PM 41.870559 -87.719668 (41.870558601, -87.719668116) 36.0 21572.0 28.0 704.0 14.0 30.0 16.0 141.0 24.0 13.619433 841.0
27 28.0 Near West Side 3.8 20.6 10.7 9.6 22.2 44689 15.0 8678186 HV352296 01/01/2012 12:00:00 AM 013XX W WASHBURNE AVE 1751 OFFENSE INVOLVING CHILDREN CRIM SEX ABUSE BY FAM MEMBER RESIDENCE False False 1231 12 2 28.0 20 1167691.0 1894516.0 2012 02/04/2016 06:33:39 AM 41.866099 -87.659865 (41.866098868, -87.659865054) 48.0 14920.0 29.0 96.0 26.0 43.0 15.0 150.0 28.0 35.867363 3364.0
28 29.0 North Lawndale 7.4 43.1 21.2 27.6 42.7 12034 87.0 9467940 HX120966 01/01/2012 12:00:00 AM 015XX S KEELER AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 1012 10 24 29.0 06 1148635.0 1892193.0 2012 02/10/2018 03:50:01 PM 41.860113 -87.729881 (41.860113198, -87.729881467) 36.0 21569.0 30.0 761.0 14.0 57.0 21.0 109.0 24.0 13.414282 1392.0
29 30.0 South Lawndale 15.2 30.7 15.8 54.8 33.8 10402 96.0 11861733 JC473689 01/01/2012 12:00:00 AM 022XX S CALIFORNIA AVE 1754 OFFENSE INVOLVING CHILDREN AGG SEX ASSLT OF CHILD FAM MBR RESIDENCE False True 1033 10 12 30.0 02 NaN NaN 2012 10/16/2019 09:37:36 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 16.730236 965.0
30 31.0 Lower West Side 9.6 25.8 15.8 40.7 32.6 16444 76.0 8538123 HV214939 01/01/2012 12:01:00 AM 021XX W 18TH ST 1754 OFFENSE INVOLVING CHILDREN AGG SEX ASSLT OF CHILD FAM MBR RESIDENCE False False 1223 12 25 31.0 02 1162499.0 1891389.0 2012 02/04/2016 06:33:39 AM 41.857628 -87.679013 (41.857628272, -87.679012753) 8.0 14920.0 33.0 4.0 26.0 43.0 15.0 121.0 25.0 20.408163 670.0
31 32.0 Loop 1.5 14.7 5.7 3.1 13.5 65526 3.0 11655969 JC225381 01/01/2012 12:00:00 AM 001XX W RANDOLPH ST 486 BATTERY DOMESTIC BATTERY SIMPLE RESIDENCE False True 122 1 42 32.0 08B NaN NaN 2012 09/07/2021 03:41:02 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 53.431563 4134.0
32 33.0 Near South Side 1.3 13.8 4.9 7.4 21.8 59077 7.0 8812790 HV485714 01/01/2012 12:01:00 AM 022XX S WABASH AVE 1150 DECEPTIVE PRACTICE CREDIT CARD FRAUD OTHER False False 131 1 2 33.0 11 1177098.0 1889498.0 2012 02/10/2018 03:50:01 PM 41.852121 -87.625483 (41.852121445, -87.625483421) 48.0 21194.0 34.0 193.0 9.0 40.0 22.0 94.0 8.0 39.086022 727.0
33 34.0 Armour Square 5.7 40.1 16.7 34.5 38.3 16148 82.0 8421660 HV100180 01/01/2012 01:20:00 AM 002XX W 26TH ST 430 BATTERY AGGRAVATED: OTHER DANG WEAPON PARKING LOT/GARAGE(NON.RESID.) True False 914 9 11 34.0 04B 1174834.0 1887065.0 2012 02/10/2018 03:50:01 PM 41.845496 -87.633866 (41.84549602, -87.633865582) 26.0 21194.0 35.0 346.0 48.0 40.0 23.0 157.0 7.0 27.890268 427.0
34 35.0 Douglas 1.8 29.6 18.2 14.3 30.7 23791 47.0 10532867 HZ276514 01/01/2012 12:00:00 AM 036XX S RHODES AVE 1563 SEX OFFENSE CRIMINAL SEXUAL ABUSE APARTMENT False True 212 2 4 35.0 17 NaN NaN 2012 09/07/2021 03:41:02 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 24.791893 685.0
35 36.0 Oakland 1.3 39.7 28.7 18.4 40.4 19252 78.0 8421472 HV100138 01/01/2012 01:38:00 AM 042XX S DREXEL BLVD 486 BATTERY DOMESTIC BATTERY SIMPLE APARTMENT False True 2123 2 4 36.0 08B 1182889.0 1876982.0 2012 02/10/2018 03:50:01 PM 41.817644 -87.604619 (41.817643766, -87.604618853) 1.0 4301.0 2.0 220.0 10.0 36.0 24.0 104.0 9.0 20.984456 162.0
36 37.0 Fuller Park 3.2 51.2 33.9 26.6 44.9 10432 97.0 9836248 HX484599 01/01/2012 12:00:00 AM 001XX W GARFIELD BLVD 1130 DECEPTIVE PRACTICE FRAUD OR CONFIDENCE GAME CURRENCY EXCHANGE True False 225 2 3 37.0 11 1176228.0 1868523.0 2012 02/10/2018 03:50:01 PM 41.794584 -87.629307 (41.794583892, -87.629307346) 12.0 21559.0 66.0 166.0 9.0 37.0 24.0 111.0 20.0 20.540098 251.0
37 38.0 Grand Boulevard 3.3 29.3 24.3 15.9 39.5 23472 57.0 8424419 HV102059 01/01/2012 03:00:00 AM 046XX S PRAIRIE AVE 281 CRIM SEXUAL ASSAULT NON-AGGRAVATED RESIDENCE False False 221 2 3 38.0 02 1178818.0 1874416.0 2012 02/10/2018 03:50:01 PM 41.810696 -87.619631 (41.810696214, -87.619630513) 12.0 4301.0 4.0 354.0 9.0 36.0 24.0 98.0 8.0 17.389187 714.0
38 39.0 Kenwood 2.4 21.7 15.7 11.3 35.4 35911 26.0 8916155 HV588860 01/01/2012 12:00:00 AM 050XX S LAKE SHORE DR W 840 THEFT FINANCIAL ID THEFT: OVER $300 APARTMENT False False 222 2 4 39.0 06 1188639.0 1871868.0 2012 02/10/2018 03:50:01 PM 41.803475 -87.583690 (41.803474876, -87.583690122) 1.0 21192.0 5.0 400.0 33.0 10.0 24.0 113.0 3.0 28.459821 510.0
39 40.0 Washington Park 5.6 42.1 28.6 25.4 42.8 13785 88.0 11571926 JC122968 01/01/2012 12:00:00 AM 059XX S INDIANA AVE 1751 OFFENSE INVOLVING CHILDREN CRIM SEX ABUSE BY FAM MEMBER APARTMENT True True 232 2 20 40.0 17 NaN NaN 2012 08/01/2019 03:45:33 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 14.751732 511.0
40 41.0 Hyde Park 1.5 18.4 8.4 4.3 26.2 39056 14.0 9091480 HW236506 01/01/2012 12:00:00 AM 055XX S COTTAGE GROVE AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 235 2 5 41.0 06 1182527.0 1868455.0 2012 02/10/2018 03:50:01 PM 41.794253 -87.606211 (41.794253414, -87.606211387) 32.0 22260.0 8.0 401.0 33.0 60.0 24.0 132.0 3.0 34.500784 660.0
41 42.0 Woodlawn 2.9 30.7 23.4 16.5 36.1 18672 58.0 8821354 HV494310 01/01/2012 12:01:00 AM 063XX S ST LAWRENCE AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 STREET False False 312 3 20 42.0 06 1181324.0 1863129.0 2012 02/10/2018 03:50:01 PM 41.779666 -87.610787 (41.779666218, -87.61078682) 53.0 22260.0 9.0 332.0 4.0 60.0 18.0 277.0 20.0 15.501576 836.0
42 43.0 South Shore 2.8 31.1 20.0 14.0 35.7 19398 55.0 9784782 HX433977 01/01/2012 12:00:00 AM 078XX S JEFFERY BLVD 265 CRIM SEXUAL ASSAULT AGGRAVATED: OTHER RESIDENCE False True 414 4 8 43.0 02 1190897.0 1853347.0 2012 09/07/2021 03:41:02 PM 41.752598 -87.576007 (41.752597535, -87.576007285) 9.0 22538.0 39.0 420.0 35.0 24.0 19.0 222.0 10.0 16.425246 1905.0
43 44.0 Chatham 3.3 27.8 24.0 14.5 40.3 18881 60.0 11012707 JA342665 01/01/2012 12:00:00 AM 081XX S EVANS AVE 1153 DECEPTIVE PRACTICE FINANCIAL IDENTITY THEFT OVER $ 300 OTHER False False 631 6 6 44.0 11 NaN NaN 2012 07/11/2017 03:48:22 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 22.336009 1614.0
44 45.0 Avalon Park 1.4 17.2 21.1 10.6 39.3 24454 41.0 8453833 HV101813 01/01/2012 12:01:00 AM 080XX S WOODLAWN AVE 1320 CRIMINAL DAMAGE TO VEHICLE STREET False False 411 4 8 45.0 14 1185609.0 1851926.0 2012 02/10/2018 03:50:01 PM 41.748824 -87.595430 (41.748824266, -87.595429995) 9.0 21546.0 41.0 133.0 35.0 61.0 19.0 224.0 10.0 25.055432 452.0
45 46.0 South Chicago 4.7 29.8 19.7 26.6 41.1 16579 75.0 8644620 HV319861 01/01/2012 12:00:00 AM 087XX S ESCANABA AVE 4651 OTHER OFFENSE SEX OFFENDER: FAIL REG NEW ADD RESIDENCE True False 423 4 10 46.0 26 1196905.0 1847568.0 2012 02/04/2016 06:33:39 AM 41.736592 -87.554183 (41.736592286, -87.554182677) 47.0 21202.0 42.0 509.0 47.0 25.0 19.0 238.0 6.0 14.649984 925.0
46 47.0 Burnside 6.8 33.0 18.6 19.3 42.7 12515 79.0 9535590 HX189319 01/01/2012 12:00:00 AM 092XX S DREXEL AVE 1153 DECEPTIVE PRACTICE FINANCIAL IDENTITY THEFT OVER $ 300 APARTMENT False False 413 4 8 47.0 11 1184166.0 1844031.0 2012 02/10/2018 03:50:01 PM 41.727193 -87.600964 (41.727193361, -87.600963809) 9.0 21546.0 43.0 472.0 35.0 61.0 19.0 246.0 10.0 17.415730 93.0
47 48.0 Calumet Heights 2.1 11.5 20.0 11.0 44.0 28887 38.0 8421496 HV100177 01/01/2012 02:10:00 AM 023XX E 91ST ST 2025 NARCOTICS POSS: HALLUCINOGENS STREET True False 413 4 7 48.0 18 1193236.0 1845085.0 2012 02/10/2018 03:50:01 PM 41.729869 -87.567705 (41.729869072, -87.56770535) 43.0 21202.0 44.0 492.0 37.0 25.0 19.0 246.0 5.0 29.205852 559.0
48 49.0 Roseland 2.5 19.8 20.3 16.9 41.2 17949 52.0 8630662 HV304328 01/01/2012 12:00:00 AM 111XX S PARNELL AVE 1562 SEX OFFENSE AGG CRIMINAL SEXUAL ABUSE RESIDENCE False True 2233 22 34 49.0 17 1174621.0 1831009.0 2012 02/04/2016 06:33:39 AM 41.691677 -87.636314 (41.691676649, -87.636314398) 45.0 21861.0 45.0 486.0 22.0 19.0 9.0 258.0 21.0 15.912117 1434.0
49 50.0 Pullman 1.5 21.6 22.8 13.1 38.6 20588 51.0 10579715 HZ328636 01/01/2012 12:00:00 AM 007XX E 105TH PL 1562 SEX OFFENSE AGG CRIMINAL SEXUAL ABUSE RESIDENCE False True 512 5 9 50.0 17 NaN NaN 2012 09/07/2021 03:41:02 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 16.454690 207.0
50 51.0 South Deering 4.0 29.2 16.3 21.0 39.5 14685 65.0 9006102 HW153435 01/01/2012 12:01:00 AM 097XX S BRENNAN AVE 841 THEFT FINANCIAL ID THEFT:$300 &UNDER RESIDENCE False False 431 4 7 51.0 06 1193243.0 1840695.0 2012 02/10/2018 03:50:01 PM 41.717822 -87.567823 (41.717822323, -87.567822714) 43.0 21202.0 48.0 252.0 37.0 25.0 19.0 249.0 5.0 17.918314 408.0
51 52.0 East Side 6.8 19.2 12.1 31.9 42.8 17104 64.0 9130410 HW275140 01/01/2012 12:00:00 AM 109XX S BUFFALO AVE 1751 OFFENSE INVOLVING CHILDREN CRIM SEX ABUSE BY FAM MEMBER RESIDENCE False True 432 4 10 52.0 20 1199876.0 1833114.0 2012 09/07/2021 03:41:02 PM 41.696855 -87.543784 (41.696854988, -87.54378378) 47.0 21202.0 49.0 602.0 47.0 25.0 19.0 247.0 6.0 15.531178 269.0
52 53.0 West Pullman 3.3 25.9 19.4 20.5 42.1 16563 62.0 10928592 JA154782 01/01/2012 12:00:00 AM 0000X E 118TH PL 1752 OFFENSE INVOLVING CHILDREN AGG CRIM SEX ABUSE FAM MEMBER RESIDENCE True True 532 5 9 53.0 20 NaN NaN 2012 09/07/2021 03:41:02 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 14.940518 854.0
53 54.0 Riverdale 5.8 56.5 34.6 27.5 51.5 8201 98.0 12364874 JE229312 01/01/2012 12:00:00 AM 131XX S FORRESTVILLE AVE 1581 SEX OFFENSE NON-CONSENSUAL DISSEMINATION OF PRIVATE SEXUAL... RESIDENCE False False 533 5 9 54.0 17 NaN NaN 2012 05/14/2021 03:40:44 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 11.047619 174.0
54 55.0 Hegewisch 3.3 17.1 9.6 19.2 42.9 22677 44.0 8438703 HV116214 01/01/2012 12:01:00 AM 134XX S AVENUE M 2820 OTHER OFFENSE TELEPHONE THREAT RESIDENCE False True 433 4 10 55.0 26 1201758.0 1816513.0 2012 02/10/2018 03:50:01 PM 41.651253 -87.537455 (41.65125265, -87.537454574) 47.0 22250.0 52.0 787.0 47.0 26.0 19.0 259.0 6.0 19.376694 143.0
55 56.0 Garfield Ridge 2.6 8.8 11.3 19.3 38.1 26353 32.0 8964421 HW112128 01/01/2012 12:01:00 AM 044XX S KILPATRICK AVE 841 THEFT FINANCIAL ID THEFT:$300 &UNDER RESIDENCE False False 815 8 23 56.0 06 1145771.0 1874717.0 2012 02/10/2018 03:50:01 PM 41.812211 -87.740837 (41.812211369, -87.740837061) 35.0 22248.0 53.0 566.0 28.0 56.0 13.0 105.0 22.0 22.066694 536.0
56 57.0 Archer Heights 8.5 14.1 16.5 35.9 39.2 16134 67.0 8550554 HV226299 01/01/2012 12:01:00 AM 050XX S KOLIN AVE 1752 OFFENSE INVOLVING CHILDREN AGG CRIM SEX ABUSE FAM MEMBER RESIDENCE False False 815 8 23 57.0 20 1148213.0 1870883.0 2012 02/10/2018 03:50:01 PM 41.801644 -87.731978 (41.801643749, -87.731978113) 35.0 22248.0 54.0 697.0 8.0 56.0 13.0 105.0 14.0 21.171548 253.0
57 58.0 Brighton Park 14.4 23.6 13.9 45.1 39.3 13089 84.0 10774674 HZ540883 01/01/2012 12:01:00 AM 045XX S TROY ST 266 CRIM SEXUAL ASSAULT PREDATORY RESIDENCE False True 922 9 14 58.0 02 NaN NaN 2012 09/07/2021 03:41:02 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 15.966123 509.0
58 59.0 McKinley Park 7.2 18.7 13.4 32.9 35.6 16954 61.0 8558693 HV234189 01/01/2012 12:00:00 AM 037XX S WOLCOTT AVE 610 BURGLARY FORCIBLE ENTRY RESIDENCE False False 912 9 11 59.0 05 1164301.0 1879957.0 2012 02/04/2016 06:33:39 AM 41.826220 -87.672721 (41.826219832, -87.67272111) 26.0 14924.0 56.0 720.0 1.0 37.0 23.0 165.0 12.0 27.761194 372.0
59 60.0 Bridgeport 4.5 18.9 13.7 22.2 31.3 22694 43.0 8697316 HV373879 01/01/2012 12:00:00 AM 027XX S EMERALD AVE 1751 OFFENSE INVOLVING CHILDREN CRIM SEX ABUSE BY FAM MEMBER RESIDENCE False False 914 9 11 60.0 20 1171748.0 1886502.0 2012 02/04/2016 06:33:39 AM 41.844020 -87.645207 (41.844019513, -87.645207358) 26.0 21194.0 58.0 688.0 48.0 40.0 23.0 157.0 7.0 23.706100 513.0
60 61.0 New City 11.9 29.0 23.0 41.5 38.9 12765 91.0 11419858 JB400896 01/01/2012 12:00:00 AM 047XX S WOOD ST 1754 OFFENSE INVOLVING CHILDREN AGG SEX ASSLT OF CHILD FAM MBR APARTMENT True True 931 9 15 61.0 02 NaN NaN 2012 01/24/2019 04:13:10 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 16.715586 1139.0
61 62.0 West Elsdon 11.1 15.6 16.7 37.0 37.7 15754 69.0 8509166 HV186479 01/01/2012 12:01:00 AM 051XX S PULASKI RD 1305 CRIMINAL DAMAGE CRIMINAL DEFACEMENT DEPARTMENT STORE True False 815 8 23 62.0 14 1150563.0 1870470.0 2012 02/10/2018 03:50:01 PM 41.800465 -87.723370 (41.800464977, -87.723370404) 35.0 22248.0 60.0 792.0 6.0 56.0 13.0 129.0 23.0 21.418129 293.0
62 63.0 Gage Park 15.8 23.4 18.2 51.5 38.8 12171 93.0 8688452 HV363336 01/01/2012 12:00:00 AM 055XX S HOMAN AVE 840 THEFT FINANCIAL ID THEFT: OVER $300 OTHER False False 822 8 14 63.0 06 1154655.0 1867673.0 2012 02/04/2016 06:33:39 AM 41.792709 -87.708438 (41.792708947, -87.708438164) 49.0 21867.0 61.0 801.0 8.0 58.0 13.0 129.0 14.0 17.424946 563.0
63 64.0 Clearing 2.7 8.9 9.5 18.8 37.6 25113 29.0 9030494 HW173536 01/01/2012 12:00:00 AM 063XX W 63RD ST 890 THEFT FROM BUILDING BANK False False 812 8 23 64.0 06 1135055.0 1862066.0 2012 02/10/2018 03:50:01 PM 41.777691 -87.780442 (41.777690785, -87.780442441) 35.0 22268.0 62.0 265.0 15.0 7.0 13.0 272.0 13.0 20.194647 249.0
64 65.0 West Lawn 5.8 14.9 9.6 33.6 39.6 16907 56.0 10244439 HY432505 01/01/2012 12:00:00 AM 039XX W 63RD PL 1153 DECEPTIVE PRACTICE FINANCIAL IDENTITY THEFT OVER $ 300 RESIDENCE False False 823 8 13 65.0 11 1151174.0 1862198.0 2012 02/10/2018 03:50:01 PM 41.777753 -87.721346 (41.777753427, -87.721345586) 23.0 21867.0 63.0 238.0 15.0 58.0 13.0 276.0 23.0 32.592593 792.0
65 66.0 Chicago Lawn 7.6 27.9 17.1 31.2 40.6 13231 80.0 8511440 HV188411 01/01/2012 12:00:00 AM 030XX W 64TH ST 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 823 8 15 66.0 06 1157262.0 1862044.0 2012 02/04/2016 06:33:39 AM 41.777210 -87.699031 (41.777209768, -87.69903082) 44.0 21867.0 64.0 319.0 31.0 58.0 13.0 276.0 15.0 15.625000 1340.0
66 67.0 West Englewood 4.8 34.4 35.9 26.3 40.7 11317 89.0 8422478 HV100112 01/01/2012 12:00:00 AM 057XX S THROOP ST 486 BATTERY DOMESTIC BATTERY SIMPLE VEHICLE NON-COMMERCIAL False True 713 7 16 67.0 08B 1168636.0 1866805.0 2012 09/07/2021 03:41:02 PM 41.790037 -87.657197 (41.790036743, -87.657196537) 19.0 22257.0 65.0 297.0 2.0 23.0 17.0 266.0 16.0 15.349910 1531.0
67 68.0 Englewood 3.8 46.6 28.0 28.5 42.5 11888 94.0 8489737 HV166954 01/01/2012 12:00:00 AM 067XX S NORMAL BLVD 1150 DECEPTIVE PRACTICE CREDIT CARD FRAUD RESIDENCE False False 722 7 6 68.0 11 1174118.0 1859976.0 2012 02/10/2018 03:50:01 PM 41.771177 -87.637298 (41.771177146, -87.637298335) 31.0 21559.0 66.0 479.0 32.0 11.0 17.0 201.0 4.0 15.333774 1392.0
68 69.0 Greater Grand Crossing 3.6 29.6 23.0 16.5 41.0 17285 66.0 8577653 HV252006 01/01/2012 12:01:00 AM 001XX E 78TH ST 2825 OTHER OFFENSE HARASSMENT BY TELEPHONE APARTMENT False False 623 6 6 69.0 26 1178686.0 1853331.0 2012 02/04/2016 06:33:39 AM 41.752840 -87.620756 (41.752839871, -87.620755566) 31.0 21546.0 67.0 475.0 32.0 61.0 20.0 228.0 4.0 15.270766 1331.0
69 70.0 Ashburn 4.0 10.4 11.7 17.7 36.9 23482 37.0 8621247 HV291039 01/01/2012 12:00:00 AM 028XX W 84TH PL 840 THEFT FINANCIAL ID THEFT: OVER $300 RESIDENCE False False 835 8 18 70.0 06 1158673.0 1848550.0 2012 02/04/2016 06:33:39 AM 41.740151 -87.694226 (41.740151493, -87.694225587) 6.0 4300.0 69.0 217.0 30.0 8.0 13.0 226.0 18.0 20.178042 544.0
70 71.0 Auburn Gresham 4.0 27.6 28.3 18.5 41.9 15528 74.0 12448101 JE331623 01/01/2012 12:00:00 AM 079XX S ELIZABETH ST 1195 DECEPTIVE PRACTICE FINANCIAL EXPLOITATION OF AN ELDERLY OR DISABL... RESIDENCE False False 612 6 21 71.0 11 NaN NaN 2012 08/10/2021 03:41:28 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 15.192430 1429.0
71 72.0 Beverly 0.9 5.1 8.0 3.7 40.5 39523 12.0 8692747 HV368620 01/01/2012 12:00:00 AM 090XX S OAKLEY AVE 2825 OTHER OFFENSE HARASSMENT BY TELEPHONE RESIDENCE False False 2221 22 19 72.0 26 1162617.0 1844687.0 2012 02/04/2016 06:33:39 AM 41.729470 -87.679883 (41.729469531, -87.679882632) 33.0 22212.0 71.0 627.0 42.0 59.0 9.0 245.0 19.0 29.906542 352.0
72 73.0 Washington Height 1.1 16.9 20.8 13.7 42.6 19713 48.0 12586134 JF104706 01/01/2012 12:00:00 AM 010XX W 97TH PL 1153 DECEPTIVE PRACTICE FINANCIAL IDENTITY THEFT OVER $ 300 NaN False False 2223 22 34 73.0 11 NaN NaN 2012 01/07/2022 03:44:31 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 18.636364 738.0
73 74.0 Mount Greenwood 1.0 3.4 8.7 4.3 36.8 34381 16.0 9566017 HX216941 01/01/2012 12:01:00 AM 032XX W 114TH ST 1751 OFFENSE INVOLVING CHILDREN CRIM SEX ABUSE BY FAM MEMBER RESIDENCE False True 2211 22 19 74.0 20 1156983.0 1829019.0 2012 09/07/2021 03:41:02 PM 41.686589 -87.700943 (41.686589225, -87.70094317) 33.0 4447.0 73.0 264.0 42.0 33.0 9.0 254.0 19.0 29.601227 193.0
74 75.0 Morgan Park 0.8 13.2 15.0 10.8 40.3 27149 30.0 8903224 HV577354 01/01/2012 12:00:00 AM 013XX W 112TH PL 841 THEFT FINANCIAL ID THEFT:$300 &UNDER RESIDENCE False False 2234 22 34 75.0 06 1169238.0 1830118.0 2012 02/10/2018 03:50:01 PM 41.689349 -87.656048 (41.689349439, -87.656047862) 45.0 22212.0 74.0 663.0 22.0 13.0 9.0 263.0 21.0 23.643123 636.0
75 76.0 O'Hare 3.6 15.4 7.1 10.9 30.3 25828 24.0 8421756 HV100392 01/01/2012 05:30:00 AM 052XX N OAKVIEW AVE 1365 CRIMINAL TRESPASS TO RESIDENCE OTHER True False 1614 16 41 76.0 26 1117315.0 1933551.0 2012 02/10/2018 03:50:01 PM 41.974152 -87.843985 (41.9741522, -87.843985377) 34.0 4448.0 75.0 8.0 29.0 31.0 12.0 44.0 41.0 31.203224 542.0
76 77.0 Edgewater 4.1 18.2 9.2 9.7 23.8 33385 19.0 11206130 JB117907 01/01/2012 12:00:00 AM 059XX N RIDGE AVE 266 CRIM SEXUAL ASSAULT PREDATORY RESIDENCE False True 2013 20 48 77.0 02 NaN NaN 2012 05/14/2019 04:05:19 PM NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN 30.444104 994.0
77 NaN CHICAGO 4.7 19.7 12.9 19.5 33.5 28202 NaN 8421956 HV100653 01/01/2012 11:15:00 AM 083XX S HOLLAND RD 860 THEFT RETAIL THEFT DEPARTMENT STORE True False 622 6 21 NaN 06 1175640.0 1849717.0 2012 02/04/2016 06:33:39 AM 41.742991 -87.632026 (41.742991296, -87.632025815) 18.0 21554.0 40.0 1.0 13.0 59.0 20.0 236.0 21.0 NaN NaN
In [15]:
import altair as alt

# Prepare the data for the grouped bar chart: melt the DataFrame
melted_data = socioeconomicMerge.melt(id_vars='COMMUNITY AREA NAME',
                                      value_vars=['Theft Percentage', 'PERCENT HOUSEHOLDS BELOW POVERTY'],
                                      var_name='Metric',
                                      value_name='Percentage')

# Create the grouped bar chart
chart = alt.Chart(melted_data).mark_bar().encode(
    x=alt.X('COMMUNITY AREA NAME:N', axis=alt.Axis(title='Community Area', labelAngle=-45)),  # Adjust label angle for readability
    y=alt.Y('Percentage:Q', axis=alt.Axis(title='Percentage (%)')),  # Scale set to [0, 100]
    color='Metric:N',
    column='Metric:N',
    order=alt.Order(
      'Metric:N',
      sort='ascending'
    ),
    tooltip=['COMMUNITY AREA NAME', 'Metric', 'Percentage']
).properties(
    width=500  # Adjust width as necessary
)

chart.display()
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():
In [16]:
melted_data = socioeconomicMerge.melt(id_vars='COMMUNITY AREA NAME',
                                      value_vars=['Theft Percentage', 'PERCENT HOUSEHOLDS BELOW POVERTY'],
                                      var_name='Metric',
                                      value_name='Percentage')

# Create the grouped bar chart
chart = alt.Chart(melted_data).mark_bar().encode(
    x=alt.X('Metric:N', axis=alt.Axis(title='Metric')),
    y=alt.Y('Percentage:Q', axis=alt.Axis(title='Percentage (%)')),
    color='Metric:N',
    column='COMMUNITY AREA NAME:N',
    tooltip=['COMMUNITY AREA NAME', 'Metric', 'Percentage']
).properties(
    width=40  # Width of each grouped bar set
)

chart.display()
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():
In [17]:
scatter_plot = alt.Chart(socioeconomicMerge).mark_circle().encode(
    x=alt.X('Theft Percentage:Q', title='Theft Percentage (%)'),
    y=alt.Y('PERCENT HOUSEHOLDS BELOW POVERTY:Q', title='% Households Below Poverty'),
    tooltip=['COMMUNITY AREA NAME:N', 'New Theft Percentage:Q', 'PERCENT HOUSEHOLDS BELOW POVERTY:Q'],
    color=alt.Color('COMMUNITY AREA NAME:N', legend=None)  # Color each point by community area (optional)
).properties(
    width=600,  # Adjust width as needed
    height=400,  # Adjust height as needed
    title="Theft Percentage vs. % Households Below Poverty by Community Area"
)

scatter_plot.display()
In [18]:
scatter_plot = alt.Chart(socioeconomicMerge).mark_circle().encode(
    x=alt.X('Theft Count:Q', title='Theft Count'),
    y=alt.Y('PERCENT HOUSEHOLDS BELOW POVERTY:Q', title='% Households Below Poverty'),
    size='PERCENT HOUSEHOLDS BELOW POVERTY:Q',
    tooltip=['COMMUNITY AREA NAME:N', 'Theft Count:Q', 'PERCENT HOUSEHOLDS BELOW POVERTY:Q'],
    color=alt.Color('COMMUNITY AREA NAME:N', legend=None)  # Color each point by community area (optional)
).properties(
    width=600,  # Adjust width as needed
    height=400,  # Adjust height as needed
    title="Theft Count vs. % Households Below Poverty by Community Area"
)

scatter_plot.display()
In [19]:
total_thefts = socioeconomicMerge['Theft Count'].sum()
total_thefts
Out[19]:
74683.0
In [20]:
# create a visualization with socioeconomic factors for Chicago overall
import pandas as pd
import altair as alt


# Extracting the CHICAGO row
chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'CHICAGO']

# Columns representing socioeconomic factors with percentages
columns_to_extract = [
    'PERCENT HOUSEHOLDS BELOW POVERTY',
    'PERCENT AGED 16+ UNEMPLOYED',
    'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'

]


chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')


chicagoChart = alt.Chart(chicago_percentages).mark_bar().encode(
    y=alt.Y('Factors:N', title = 'Factors'),
    x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),
    tooltip=('Percentage')).properties(
        width = 600,
        title = 'Socioeconomic Factors in All of Chicago'
    )

chicagoChart
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():
Out[20]:
In [21]:
chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'Fuller Park']

# Columns representing socioeconomic factors with percentages
columns_to_extract = [
    'PERCENT HOUSEHOLDS BELOW POVERTY',
    'PERCENT AGED 16+ UNEMPLOYED',
    'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'

]


chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')


chicagoChart = alt.Chart(chicago_percentages).mark_bar(color='purple').encode(
    y=alt.Y('Factors:N', title = 'Factors'),
    x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),tooltip=('Percentage')).properties(
        width = 600,
        title = 'Socioeconomic Factors in Fuller Park Community Area'
    )

chicagoChart
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():
Out[21]:
In [22]:
chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'Riverdale']

# Columns representing socioeconomic factors with percentages
columns_to_extract = [

    'PERCENT HOUSEHOLDS BELOW POVERTY',
    'PERCENT AGED 16+ UNEMPLOYED',
    'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'

]


chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')


chicagoChart = alt.Chart(chicago_percentages).mark_bar(color='orange').encode(
    y=alt.Y('Factors:N', title = 'Factors'),
    x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),tooltip=('Percentage')).properties(
        width = 600,
        title = 'Socioeconomic Factors in Riverdale Community Area'
    )

chicagoChart
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():
Out[22]:
In [23]:
# highest amount of thefts according to theft count
chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'Near North Side']

# Columns representing socioeconomic factors with percentages
columns_to_extract = [

    'PERCENT HOUSEHOLDS BELOW POVERTY',
    'PERCENT AGED 16+ UNEMPLOYED',
    'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'

]


chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')


chicagoChart = alt.Chart(chicago_percentages).mark_bar(color='pink').encode(
    y=alt.Y('Factors:N', title = 'Factors'),
    x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),tooltip=('Percentage')).properties(
        width = 600,
        title = 'Socioeconomic Factors in Near North Side Community Area'
    )

chicagoChart
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():
Out[23]:
In [24]:
# lowest amount of thefts according to scatterplot
chicagoOverllSocioeconomic = socioeconomicMerge[socioeconomicMerge['COMMUNITY AREA NAME'] == 'Edison Park']

# Columns representing socioeconomic factors with percentages
columns_to_extract = [

    'PERCENT HOUSEHOLDS BELOW POVERTY',
    'PERCENT AGED 16+ UNEMPLOYED',
    'PERCENT AGED 25+ WITHOUT HIGH SCHOOL DIPLOMA'

]


chicago_percentages = chicagoOverllSocioeconomic[columns_to_extract].melt( value_vars = columns_to_extract, var_name='Factors',value_name='Percentage')


chicagoChart = alt.Chart(chicago_percentages).mark_bar(color='green').encode(
    y=alt.Y('Factors:N', title = 'Factors'),
    x=alt.X('Percentage:Q', title = 'Percentage',scale=alt.Scale(domain=[0,60])),tooltip=('Percentage')).properties(
        width = 600,
        title = 'Socioeconomic Factors in Edison Park Community Area'
    )

chicagoChart
/opt/conda/lib/python3.10/site-packages/altair/utils/core.py:317: FutureWarning: iteritems is deprecated and will be removed in a future version. Use .items instead.
  for col_name, dtype in df.dtypes.iteritems():
Out[24]:
In [ ]:
 
In [ ]:
 
In [ ]: